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 | 185 | 987867978768 | 5339826888 | 36331396992 | 975976848 | 21777933936 | 965114067984 | 8 | 70656 | 8832.0000 | 100 | 126976 | 1269.7600 | |
innodb/innodb_data_file | 1617 | 935807468640 | 578730504 | 67317245952 | 178527813552 | 16318221744 | 740961433344 | 1224 | 22462464 | 18351.6863 | 284 | 18923520 | 66632.1127 | |
innodb/innodb_temp_file | 202 | 450067528416 | 2228057040 | 31150029504 | 0 | 3227350368 | 446840178048 | 0 | 0 | 0.0000 | 135 | 3325952 | 24636.6815 | |
sql/binlog | 494 | 101619789216 | 205708008 | 24349930176 | 3317943024 | 551852400 | 97749993792 | 125 | 67686 | 541.4880 | 7 | 1198 | 171.1429 | |
sql/ERRMSG | 35 | 18698266752 | 534235944 | 1950396624 | 10133161104 | 0 | 8565105648 | 21 | 2146110 | 102195.7143 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 2766887904 | 120299256 | 1784278320 | 2050404576 | 0 | 716483328 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
sql/io_cache | 46 | 959766192 | 20864448 | 88484352 | 116646816 | 519750000 | 323369376 | 16 | 1150596 | 71912.2500 | 20 | 1150596 | 57529.8000 | |
sql/casetest | 15 | 764657520 | 50977080 | 673676256 | 0 | 0 | 764657520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 476088624 | 79348104 | 457991952 | 5960592 | 0 | 470128032 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 445463040 | 148487592 | 420734688 | 420734688 | 0 | 24728352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 232156848 | 46431264 | 204667584 | 205843968 | 0 | 26312880 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 217296288 | 54324072 | 151939920 | 151939920 | 0 | 65356368 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 80448192 | 20112048 | 31001520 | 0 | 0 | 80448192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12026256 | 4008576 | 10020912 | 0 | 1437216 | 10589040 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|