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 | 1161 | 5807773440480 | 5002388688 | 119157586944 | 986586480 | 143307113664 | 5663479740336 | 8 | 70656 | 8832.0000 | 690 | 627200 | 908.9855 | |
innodb/innodb_data_file | 3688 | 2900846419680 | 786563448 | 77561821392 | 233325621936 | 50858000688 | 2616662797056 | 1641 | 32882688 | 20038.2011 | 1516 | 57655296 | 38031.1979 | |
innodb/innodb_temp_file | 395 | 736165193808 | 1863709320 | 35522260224 | 0 | 6095370864 | 730069822944 | 0 | 0 | 0.0000 | 305 | 7618560 | 24978.8852 | |
sql/binlog | 1113 | 178961832192 | 160792104 | 19981291968 | 14014848144 | 1492388832 | 163454595216 | 290 | 212153 | 731.5621 | 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 |
|