SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 4626 | 20446689634800 | 4419950040 | 62533781904 | 865156512 | 798730381152 | 19647094097136 | 8 | 70656 | 8832.0000 | 3060 | 5785600 | 1890.7190 | |
innodb/innodb_data_file | 5044 | 6826847976432 | 1353459096 | 190523080176 | 219765092448 | 107697947280 | 6499384936704 | 1437 | 29048832 | 20214.9144 | 2332 | 86491136 | 37088.8233 | |
sql/binlog | 483 | 1224324280080 | 2534832696 | 30741166368 | 1802689680 | 5177664624 | 1217343925776 | 72 | 12848 | 178.4444 | 97 | 28145 | 290.1546 | |
innodb/innodb_temp_file | 142 | 671996517456 | 4732369752 | 40085938464 | 0 | 2702677824 | 669293839632 | 0 | 0 | 0.0000 | 63 | 2932736 | 46551.3651 | |
sql/ERRMSG | 60 | 33877918272 | 564631848 | 3277559472 | 18301055520 | 0 | 15576862752 | 36 | 3684241 | 102340.0278 | 0 | 0 | 0.0000 | |
sql/io_cache | 280 | 18213768144 | 65049072 | 11727729024 | 809552304 | 3720391488 | 13683824352 | 124 | 6975746 | 56256.0161 | 116 | 6975746 | 60135.7414 | |
sql/binlog_index | 23 | 865422096 | 37626864 | 294262848 | 238288512 | 0 | 627133584 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 766086816 | 51072384 | 685798080 | 0 | 0 | 766086816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 368283168 | 73656528 | 352594704 | 353738880 | 0 | 14544288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 353412576 | 88353144 | 197798304 | 197798304 | 0 | 155614272 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 296940864 | 98980200 | 281417664 | 281417664 | 0 | 15523200 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 283230288 | 47205048 | 266123616 | 5833872 | 0 | 277396416 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 241932768 | 60483192 | 179732784 | 0 | 0 | 241932768 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 233543904 | 25949088 | 158218896 | 0 | 0 | 233543904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 27447024 | 6861624 | 9098496 | 0 | 0 | 27447024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18169008 | 6056160 | 14573328 | 0 | 2662176 | 15506832 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|