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 | 1046 | 5209560971472 | 4980459792 | 119157586944 | 986586480 | 126378502272 | 5082195882720 | 8 | 70656 | 8832.0000 | 621 | 572928 | 922.5894 | |
innodb/innodb_data_file | 3435 | 2622983814528 | 763604952 | 77561821392 | 227060738784 | 47441127888 | 2348481947856 | 1636 | 32800768 | 20049.3692 | 1298 | 50806784 | 39142.3606 | |
innodb/innodb_temp_file | 380 | 659959640208 | 1736735880 | 35522260224 | 0 | 5735437488 | 654224202720 | 0 | 0 | 0.0000 | 295 | 7127040 | 24159.4576 | |
sql/binlog | 953 | 178619052480 | 187428120 | 19981291968 | 13961740320 | 1492388832 | 163164923328 | 250 | 211993 | 847.9720 | 12 | 3257 | 271.4167 | |
sql/ERRMSG | 35 | 18938379504 | 541096512 | 3363210576 | 9287516832 | 0 | 9650862672 | 21 | 2160943 | 102902.0476 | 0 | 0 | 0.0000 | |
myisam/kfile | 24 | 2057909040 | 85746144 | 882955920 | 1965596688 | 0 | 92312352 | 12 | 2346 | 195.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1132472880 | 226494576 | 1104593952 | 1105895472 | 0 | 26577408 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 982810224 | 65520576 | 902149776 | 0 | 0 | 982810224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 970281840 | 42186144 | 241050480 | 541087008 | 0 | 429194832 | 5 | 288 | 57.6000 | 0 | 0 | 0.0000 | |
sql/io_cache | 38 | 795173808 | 20925432 | 61120752 | 106492848 | 399729792 | 288951168 | 10 | 1026630 | 102663.0000 | 18 | 1026630 | 57035.0000 | |
myisam/dfile | 81 | 716523984 | 8845848 | 238929504 | 232991088 | 0 | 483532896 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 357815040 | 119271504 | 344602368 | 344602368 | 0 | 13212672 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 21985392 | 10992696 | 16185312 | 0 | 0 | 21985392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17021136 | 5673624 | 13232208 | 0 | 2870736 | 14150400 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|