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 | 311 | 1500764632224 | 4825609536 | 31100957712 | 932558880 | 15490789248 | 1484341284096 | 8 | 70656 | 8832.0000 | 179 | 201216 | 1124.1117 | |
innodb/innodb_data_file | 2121 | 1313301456720 | 619189560 | 59703357120 | 199222708608 | 18115073856 | 1095963674256 | 1409 | 29474816 | 20918.9610 | 374 | 21577728 | 57694.4599 | |
innodb/innodb_temp_file | 727 | 844703063952 | 1161902280 | 129964785984 | 0 | 138380319792 | 706322744160 | 0 | 0 | 0.0000 | 642 | 12812288 | 19956.8349 | |
sql/binlog | 279 | 93173379024 | 333954720 | 22179567696 | 5092783872 | 893553408 | 87187041744 | 66 | 9497 | 143.8939 | 7 | 1839 | 262.7143 | |
sql/ERRMSG | 65 | 39909159312 | 613986912 | 3442136016 | 22113980064 | 0 | 17795179248 | 39 | 3988507 | 102269.4103 | 0 | 0 | 0.0000 | |
sql/io_cache | 104 | 18862065552 | 181365888 | 10950693600 | 291979248 | 3343271712 | 15226814592 | 36 | 2651732 | 73659.2222 | 48 | 2651732 | 55244.4167 | |
myisam/kfile | 12 | 2475383856 | 206281944 | 1131125424 | 2424147792 | 0 | 51236064 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 844752480 | 56316744 | 746966880 | 0 | 0 | 844752480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 784074192 | 34090056 | 260070096 | 187052976 | 0 | 597021216 | 5 | 288 | 57.6000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 443030016 | 147676584 | 401792688 | 401792688 | 0 | 41237328 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 214828416 | 42965472 | 194608656 | 195445536 | 0 | 19382880 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 204852912 | 51213096 | 141318672 | 141318672 | 0 | 63534240 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 197919216 | 65973072 | 179606064 | 0 | 0 | 197919216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 32897040 | 4699464 | 10560528 | 0 | 0 | 32897040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 24096336 | 4015968 | 9553632 | 5709264 | 0 | 18387072 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13544256 | 4514664 | 11204160 | 0 | 1714416 | 11829840 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|