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 | 4637 | 20519187778848 | 4425099624 | 62533781904 | 865156512 | 799051595232 | 19719271027104 | 8 | 70656 | 8832.0000 | 3067 | 5789184 | 1887.5722 | |
innodb/innodb_data_file | 5056 | 6878836042848 | 1360529280 | 190523080176 | 219765092448 | 107853575280 | 6551217375120 | 1437 | 29048832 | 20214.9144 | 2339 | 86687744 | 37061.8829 | |
sql/binlog | 523 | 1224436385040 | 2341178400 | 30741166368 | 1819325904 | 5177664624 | 1217439394512 | 82 | 12888 | 157.1707 | 97 | 28145 | 290.1546 | |
innodb/innodb_temp_file | 145 | 689031974928 | 4751944560 | 40085938464 | 0 | 2771408112 | 686260566816 | 0 | 0 | 0.0000 | 65 | 3031040 | 46631.3846 | |
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 |
|