SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 1932 | 1435335130416 | 0 | 742926888 | 266102164944 | 1368 | 27525120 | 20120.7018 | 304 | 19546112 | 64296.4211 | 47071232 | |
sql/ERRMSG | 85 | 41840054256 | 2672736 | 492235920 | 2537423856 | 51 | 5217088 | 102295.8431 | 0 | 0 | 0.0000 | 5217088 | |
innodb/innodb_temp_file | 114 | 529452448272 | 0 | 4644319680 | 32953412976 | 0 | 0 | 0.0000 | 46 | 1933312 | 42028.5217 | 1933312 | |
innodb/innodb_log_file | 254 | 1820695391328 | 231792 | 7168091832 | 258773418816 | 8 | 70656 | 8832.0000 | 142 | 135680 | 955.4930 | 206336 | |
mysys/charset | 3 | 315836400 | 2091936 | 105278712 | 301353360 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 316 | 60170687808 | 0 | 190413432 | 19593041952 | 75 | 896 | 11.9467 | 5 | 11900 | 2380.0000 | 12796 | |
myisam/kfile | 4 | 1608140688 | 2556048 | 402035040 | 1539140592 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 49484360112 | 0 | 1302219864 | 24144116304 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 913985424 | 260832 | 182797032 | 897612672 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1662676752 | 524304 | 415669056 | 1382174640 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 59686176 | 2962608 | 19895304 | 36177504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 758696928 | 0 | 50579760 | 691420224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12910656 | 0 | 12910656 | 12910656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 192698880 | 0 | 32116392 | 164969904 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 3 | 43339296 | 305712 | 14446344 | 33435600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|