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 | 455 | 2468253666912 | 5424733248 | 63245988960 | 1765869072 | 48424220064 | 2418063577776 | 8 | 70656 | 8832.0000 | 265 | 287232 | 1083.8943 | |
innodb/innodb_data_file | 2350 | 2021134468848 | 860057088 | 227336398608 | 238343316288 | 22410850704 | 1760380301856 | 1435 | 28622848 | 19946.2355 | 606 | 28950528 | 47773.1485 | |
innodb/innodb_temp_file | 142 | 662780186112 | 4667465880 | 38353705632 | 0 | 3812915040 | 658967271072 | 0 | 0 | 0.0000 | 65 | 2834432 | 43606.6462 | |
sql/binlog | 301 | 163610156160 | 543555144 | 27512716176 | 2230425648 | 706178880 | 160673551632 | 68 | 868 | 12.7647 | 11 | 2043 | 185.7273 | |
sql/binlog_index | 38 | 47174543856 | 1241435184 | 25932914832 | 2090822448 | 0 | 45083721408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 39054911808 | 600844728 | 3784149072 | 17744947440 | 0 | 21309964368 | 39 | 3990997 | 102333.2564 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 14033274288 | 1754159088 | 13429390656 | 419176032 | 0 | 13614098256 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 5992863360 | 1198572672 | 5927704464 | 5932174512 | 0 | 60688848 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1187308848 | 79153800 | 1122700128 | 0 | 0 | 1187308848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 863679696 | 215919792 | 810581904 | 0 | 0 | 863679696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 607413312 | 151853328 | 587755872 | 589804512 | 0 | 17608800 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 237471696 | 79157232 | 224626512 | 224626512 | 0 | 12845184 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 66447216 | 22149072 | 47180496 | 0 | 16390704 | 50056512 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 5 | 61722144 | 12344376 | 14098656 | 0 | 0 | 61722144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 8697744 | 4348872 | 8282736 | 0 | 0 | 8697744 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|