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 | 1831 | 8655690022770 | 4727301875 | 623214074890 | 1966555460 | 402044298440 | 8251679168870 | 8 | 70656 | 8832.0000 | 1277 | 2339328 | 1831.8935 | |
innodb/innodb_data_file | 3207 | 3992097731630 | 1244807290 | 530253306610 | 631484768880 | 100641174240 | 3259971788510 | 1462 | 29065216 | 19880.4487 | 1163 | 46710784 | 40164.0447 | |
innodb/innodb_temp_file | 216 | 672773868210 | 3114693665 | 32766726890 | 0 | 4463989130 | 668309879080 | 0 | 0 | 0.0000 | 142 | 3899392 | 27460.5070 | |
sql/binlog | 303 | 633627211730 | 2091178865 | 32946721250 | 4038648760 | 5090092970 | 624498470000 | 54 | 812 | 15.0370 | 40 | 8195 | 204.8750 | |
sql/io_cache | 428 | 66197090100 | 154665925 | 25985497730 | 1115731090 | 40563849450 | 24517509560 | 164 | 10440128 | 63659.3171 | 184 | 10440128 | 56739.8261 | |
sql/binlog_index | 38 | 44425934010 | 1169103415 | 21880607980 | 3153385520 | 0 | 41272548490 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 35971669750 | 719433395 | 5554524550 | 16253153310 | 0 | 19718516440 | 30 | 3069505 | 102316.8333 | 0 | 0 | 0.0000 | |
myisam/kfile | 14 | 2618971150 | 187069330 | 1086472970 | 1719773150 | 0 | 899198000 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1326120950 | 88407975 | 1233029630 | 0 | 0 | 1326120950 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 449749520 | 89949745 | 428984650 | 430772340 | 0 | 18977180 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 312535170 | 104178390 | 290202560 | 290202560 | 0 | 22332610 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 10 | 107497780 | 10749725 | 36835530 | 0 | 0 | 107497780 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 52867500 | 10573500 | 14404870 | 0 | 0 | 52867500 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47634810 | 15878270 | 36642610 | 0 | 8180550 | 39454260 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|