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 | 1345 | 7474077982800 | 5556935208 | 263690719248 | 1244340768 | 753125628816 | 6719708013216 | 8 | 70656 | 8832.0000 | 807 | 663040 | 821.6109 | |
innodb/innodb_data_file | 3554 | 3406665991872 | 958544136 | 219411566352 | 402512567424 | 38905527408 | 2965247897040 | 1494 | 29589504 | 19805.5582 | 1630 | 62799872 | 38527.5288 | |
innodb/innodb_temp_file | 146 | 1272903273312 | 8718515520 | 433177047072 | 0 | 163978565520 | 1108924707792 | 0 | 0 | 0.0000 | 71 | 2801664 | 39460.0563 | |
sql/ERRMSG | 55 | 307784117520 | 5596074792 | 273601399104 | 16393161840 | 0 | 291390955680 | 33 | 3374876 | 102268.9697 | 0 | 0 | 0.0000 | |
sql/binlog | 133 | 87586735632 | 658546680 | 28166447232 | 1319255520 | 919290240 | 85348189872 | 29 | 712 | 24.5517 | 5 | 834 | 166.8000 | |
sql/binlog_index | 38 | 65084208816 | 1712742240 | 30858444672 | 3389699280 | 0 | 61694509536 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 16428687264 | 2053585776 | 15271653936 | 727432464 | 0 | 15701254800 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 282 | 7662953232 | 27173520 | 2408982576 | 863479584 | 3042445824 | 3757027824 | 140 | 6839654 | 48854.6714 | 112 | 6839654 | 61068.3393 | |
myisam/kfile | 8 | 5312271888 | 664033920 | 4540468416 | 5241627600 | 0 | 70644288 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1197154992 | 79810104 | 1131872016 | 0 | 0 | 1197154992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 553675056 | 110734800 | 534004944 | 535163904 | 0 | 18511152 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 16 | 463948848 | 28996704 | 206629632 | 34239216 | 0 | 429709632 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 204961680 | 68320560 | 191885232 | 191885232 | 0 | 13076448 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 59954928 | 8564952 | 33705408 | 0 | 0 | 59954928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 14206368 | 7103184 | 10496112 | 0 | 0 | 14206368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13161984 | 4387152 | 10584816 | 0 | 1918752 | 11243232 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|