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 | 1408 | 7508179795776 | 5332513824 | 102695888064 | 1344332880 | 275200163040 | 7231635299856 | 8 | 70656 | 8832.0000 | 863 | 1220608 | 1414.3778 | |
innodb/innodb_data_file | 3887 | 5703079348560 | 1467218544 | 194651863824 | 217239688512 | 78627183888 | 5407212476160 | 1430 | 28540928 | 19958.6909 | 1773 | 65486848 | 36935.6165 | |
innodb/innodb_temp_file | 754 | 1639537739136 | 2174453160 | 451593983280 | 0 | 564755350896 | 1074782388240 | 0 | 0 | 0.0000 | 653 | 14041088 | 21502.4319 | |
sql/binlog | 443 | 409189028688 | 923677128 | 28895986416 | 1800160560 | 4216967568 | 403171900560 | 95 | 976 | 10.2737 | 28 | 8195 | 292.6786 | |
sql/binlog_index | 38 | 56345363184 | 1482772632 | 28685321808 | 184998000 | 0 | 56160365184 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 30660511728 | 557463720 | 4986390816 | 17336222112 | 0 | 13324289616 | 33 | 3382489 | 102499.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 50 | 22098698688 | 441973752 | 21130458624 | 141315504 | 517311168 | 21440072016 | 18 | 1286688 | 71482.6667 | 22 | 1286688 | 58485.8182 | |
mysys/cnf | 5 | 1218536352 | 243707112 | 1191844896 | 1193067216 | 0 | 25469136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 939994704 | 117499272 | 685330272 | 881773200 | 0 | 58221504 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 736376784 | 49091592 | 659538000 | 0 | 0 | 736376784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 182082384 | 60694128 | 168645840 | 168645840 | 0 | 13436544 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 63923376 | 12784464 | 21785808 | 0 | 0 | 63923376 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 37129488 | 9282240 | 25563120 | 0 | 0 | 37129488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15901248 | 5300328 | 10242672 | 0 | 4984320 | 10916928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|