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 | 1690 | 9606667721904 | 5684418696 | 319111057056 | 1479029904 | 391435202928 | 9213753489072 | 8 | 70656 | 8832.0000 | 1025 | 1097728 | 1070.9541 | |
innodb/innodb_data_file | 3762 | 5745494989344 | 1527244752 | 231768108528 | 308093904624 | 66421760064 | 5370979324656 | 1497 | 29638656 | 19798.7014 | 1632 | 60735488 | 37215.3725 | |
innodb/innodb_temp_file | 176 | 929325545808 | 5280258720 | 38219166480 | 0 | 4804070832 | 924521474976 | 0 | 0 | 0.0000 | 88 | 3932160 | 44683.6364 | |
sql/binlog | 917 | 386794851168 | 421804416 | 23449971072 | 1212070464 | 5751577920 | 379831202784 | 214 | 1452 | 6.7850 | 27 | 8602 | 318.5926 | |
sql/binlog_index | 38 | 50751267072 | 1335559632 | 27532412160 | 347249760 | 0 | 50404017312 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 39928264464 | 665470872 | 3856108080 | 21170675856 | 0 | 18757588608 | 36 | 3687420 | 102428.3333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4027572384 | 503446416 | 1836990672 | 2105673504 | 0 | 1921898880 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2017117872 | 126069768 | 618153888 | 1949516448 | 0 | 67601424 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1078187616 | 71879016 | 1004289264 | 0 | 0 | 1078187616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 8 | 791337888 | 98917104 | 685205136 | 38907792 | 0 | 752430096 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 573777072 | 114755256 | 554413728 | 555815568 | 0 | 17961504 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 311268672 | 103756224 | 297748176 | 297748176 | 0 | 13520496 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 11 | 188843424 | 17167392 | 32630400 | 0 | 0 | 188843424 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 58355088 | 19451520 | 35558160 | 0 | 19769376 | 38585712 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 8 | 30637728 | 3829584 | 9353520 | 0 | 0 | 30637728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|