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 | 4660 | 22184728242336 | 4760671080 | 157464750432 | 1348307136 | 1018902445968 | 21164477489232 | 8 | 70656 | 8832.0000 | 3174 | 5527040 | 1741.3485 | |
innodb/innodb_data_file | 5556 | 10671018419952 | 1920629568 | 246407338320 | 344173715424 | 207252124464 | 10119592580064 | 1387 | 27836416 | 20069.5141 | 2870 | 101597184 | 35399.7157 | |
sql/binlog | 537 | 1307016559728 | 2433922656 | 30717019872 | 3440370912 | 5040468048 | 1298535720768 | 90 | 956 | 10.6222 | 85 | 27916 | 328.4235 | |
innodb/innodb_temp_file | 297 | 1121122177824 | 3774821952 | 33768627024 | 0 | 7939104096 | 1113183073728 | 0 | 0 | 0.0000 | 196 | 6553600 | 33436.7347 | |
sql/ERRMSG | 75 | 54599477856 | 727992936 | 4064997024 | 29309488032 | 0 | 25289989824 | 45 | 4608343 | 102407.6222 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 46869705168 | 1233413280 | 25788120336 | 1910281824 | 0 | 44959423344 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 4172509968 | 1043127360 | 3906528384 | 0 | 0 | 4172509968 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2285859312 | 285732216 | 1177266816 | 1747244928 | 0 | 538614384 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 54 | 2227257648 | 41245512 | 1404024864 | 1945907040 | 0 | 281350608 | 21 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 935680944 | 187136136 | 914452704 | 915993408 | 0 | 19687536 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 744440400 | 49629360 | 670763280 | 0 | 0 | 744440400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 7 | 683659152 | 97665480 | 588810816 | 0 | 0 | 683659152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 550889328 | 137722200 | 517125840 | 0 | 0 | 550889328 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 518770032 | 17292264 | 42600096 | 46424400 | 281647872 | 190697760 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
mysys/charset | 3 | 306866736 | 102288912 | 291846720 | 291846720 | 0 | 15020016 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 43042032 | 14347344 | 33653136 | 0 | 7321776 | 35720256 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|