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 | 2310 | 2731202472768 | 0 | 1182338520 | 199622344944 | 1334 | 26968064 | 20215.9400 | 620 | 28950528 | 46694.4000 | 55918592 | |
sql/ERRMSG | 100 | 43150817424 | 2428800 | 431508000 | 2157850992 | 60 | 6131013 | 102183.5500 | 0 | 0 | 0.0000 | 6131013 | |
innodb/innodb_temp_file | 132 | 652008819792 | 0 | 4939460592 | 37195165920 | 0 | 0 | 0.0000 | 60 | 2424832 | 40413.8667 | 2424832 | |
innodb/innodb_log_file | 483 | 2749985373696 | 217536 | 5693551248 | 78464253120 | 8 | 70656 | 8832.0000 | 270 | 256000 | 948.1481 | 326656 | |
sql/binlog | 910 | 350622166752 | 0 | 385299024 | 22322160432 | 212 | 1444 | 6.8113 | 29 | 37754 | 1301.8621 | 39198 | |
sql/SDI | 18 | 1758726288 | 2651088 | 97706928 | 1422080352 | 0 | 0 | 0.0000 | 6 | 37111 | 6185.1667 | 37111 | |
myisam/dfile | 519 | 16227146496 | 77616 | 31266048 | 12774216576 | 101 | 6390 | 63.2673 | 341 | 28144 | 82.5337 | 34534 | |
mysys/charset | 3 | 224588496 | 1677984 | 74862744 | 212901216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 136 | 3445882704 | 308352 | 25337136 | 1741937472 | 20 | 4161 | 208.0500 | 78 | 3196 | 40.9744 | 7357 | |
sql/binlog_index | 38 | 43651087920 | 0 | 1148712840 | 27389039040 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 8831225040 | 420288 | 1766245008 | 8803186128 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 14216400 | 741312 | 4738800 | 11718432 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1155209616 | 0 | 77013816 | 1093064016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 80260752 | 0 | 13376616 | 21215568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|