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 | 2037 | 11488219824048 | 5639773920 | 263690719248 | 1244340768 | 850108777584 | 10636866705696 | 8 | 70656 | 8832.0000 | 1218 | 960000 | 788.1773 | |
innodb/innodb_data_file | 4591 | 4871207042064 | 1061033952 | 219411566352 | 412207637952 | 83162739792 | 4375836664320 | 1521 | 30031872 | 19744.8205 | 2520 | 89669632 | 35583.1873 | |
innodb/innodb_temp_file | 202 | 1570960118112 | 7777030272 | 433177047072 | 0 | 165357575856 | 1405602542256 | 0 | 0 | 0.0000 | 110 | 4554752 | 41406.8364 | |
sql/ERRMSG | 65 | 315158577888 | 4848593376 | 273601399104 | 19631670960 | 0 | 295526906928 | 39 | 3984361 | 102163.1026 | 0 | 0 | 0.0000 | |
sql/binlog | 277 | 89610389616 | 323502960 | 28166447232 | 2072909520 | 919290240 | 86618189856 | 65 | 856 | 13.1692 | 5 | 834 | 166.8000 | |
sql/io_cache | 774 | 65490680640 | 84613056 | 25841721840 | 2207928096 | 9727263216 | 53555489328 | 382 | 18749766 | 49083.1571 | 312 | 18749766 | 60095.4038 | |
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 | |
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 | 17 | 480125184 | 28242456 | 206629632 | 34239216 | 0 | 445885968 | 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 |
|