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 | 2232 | 1845125412768 | 0 | 826669008 | 205405902768 | 1386 | 27820032 | 20072.1732 | 519 | 26099712 | 50288.4624 | 53919744 | |
sql/ERRMSG | 80 | 39096035088 | 2930400 | 488700432 | 3798713952 | 48 | 4913511 | 102364.8125 | 0 | 0 | 0.0000 | 4913511 | |
innodb/innodb_temp_file | 135 | 582547354224 | 0 | 4315165536 | 44056028016 | 0 | 0 | 0.0000 | 60 | 2621440 | 43690.6667 | 2621440 | |
innodb/innodb_log_file | 358 | 1874483009520 | 239184 | 5235985920 | 87434898144 | 8 | 70656 | 8832.0000 | 198 | 174080 | 879.1919 | 244736 | |
mysys/charset | 3 | 321569424 | 2346432 | 107189808 | 292586448 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 373 | 30624078144 | 0 | 82101888 | 15374222160 | 90 | 956 | 10.6222 | 3 | 156 | 52.0000 | 1112 | |
myisam/kfile | 4 | 1420038048 | 1287264 | 355009512 | 1394890992 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 58834171440 | 0 | 1548267600 | 32978098560 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 454822368 | 176352 | 90964368 | 435446352 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 17028000 | 613008 | 5676000 | 10943328 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 762463152 | 0 | 50830824 | 679272000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 2788896 | 0 | 2788896 | 2788896 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 14529504 | 821040 | 7264752 | 13708464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|