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 | 6152 | 28968215399904 | 4708747560 | 535694187072 | 1468001568 | 1016273969040 | 27950473429296 | 8 | 70656 | 8832.0000 | 4011 | 7011328 | 1748.0249 | |
innodb/innodb_data_file | 7799 | 13623265051440 | 1746796128 | 430968367632 | 705960566256 | 182400159216 | 12734904325968 | 1342 | 27099136 | 20193.0969 | 4707 | 162250752 | 34470.0982 | |
sql/binlog | 651 | 1796817507408 | 2760088320 | 29007990000 | 1186239648 | 4165370880 | 1791465896880 | 96 | 980 | 10.2083 | 130 | 45027 | 346.3615 | |
innodb/innodb_temp_file | 189 | 920322014304 | 4869428520 | 23981809632 | 0 | 5492263392 | 914829750912 | 0 | 0 | 0.0000 | 97 | 4341760 | 44760.4124 | |
sql/binlog_index | 38 | 61469625888 | 1617621720 | 30523746000 | 1959902736 | 0 | 59509723152 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 34622568288 | 577042752 | 3748970544 | 18249431376 | 0 | 16373136912 | 36 | 3686637 | 102406.5833 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 6847252896 | 1711813224 | 6679902240 | 0 | 0 | 6847252896 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3348068592 | 418508376 | 2238587472 | 990192720 | 0 | 2357875872 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1212795936 | 80852904 | 1140797856 | 0 | 0 | 1212795936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 806485152 | 161296872 | 786781248 | 787975584 | 0 | 18509568 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 10 | 462683232 | 46268112 | 356549952 | 371186112 | 0 | 91497120 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 398190672 | 99547536 | 347306784 | 0 | 0 | 398190672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 336483312 | 112160928 | 323568960 | 323568960 | 0 | 12914352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 12 | 148308336 | 12358896 | 28591728 | 0 | 0 | 148308336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 55484880 | 18494784 | 35779392 | 0 | 16796208 | 38688672 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|