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 | 1157 | 5779661850336 | 4995386088 | 119157586944 | 986586480 | 143272228704 | 5635403035152 | 8 | 70656 | 8832.0000 | 688 | 626176 | 910.1395 | |
innodb/innodb_data_file | 3677 | 2871649407264 | 780976152 | 77561821392 | 232489055040 | 50788934592 | 2588371417632 | 1637 | 32817152 | 20047.1301 | 1514 | 57622528 | 38059.7939 | |
innodb/innodb_temp_file | 395 | 736165193808 | 1863709320 | 35522260224 | 0 | 6095370864 | 730069822944 | 0 | 0 | 0.0000 | 305 | 7618560 | 24978.8852 | |
sql/binlog | 1097 | 178930093056 | 163108440 | 19981291968 | 14009829504 | 1492388832 | 163427874720 | 286 | 212137 | 741.7378 | 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 |
|