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 | 1952 | 10973944496064 | 5621897688 | 263690719248 | 1244340768 | 842198490144 | 10130501665152 | 8 | 70656 | 8832.0000 | 1168 | 923136 | 790.3562 | |
innodb/innodb_data_file | 4314 | 4548404502048 | 1054335744 | 219411566352 | 412207637952 | 55243225488 | 4080953638608 | 1521 | 30031872 | 19744.8205 | 2262 | 81444864 | 36005.6870 | |
innodb/innodb_temp_file | 194 | 1527871430448 | 7875625824 | 433177047072 | 0 | 165086652192 | 1362784778256 | 0 | 0 | 0.0000 | 105 | 4276224 | 40725.9429 | |
sql/ERRMSG | 65 | 315158577888 | 4848593376 | 273601399104 | 19631670960 | 0 | 295526906928 | 39 | 3984361 | 102163.1026 | 0 | 0 | 0.0000 | |
sql/binlog | 261 | 89167858560 | 341639232 | 28166447232 | 1719767808 | 919290240 | 86528800512 | 61 | 840 | 13.7705 | 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 | 674 | 15556692624 | 23080992 | 2408982576 | 1948920336 | 8057136912 | 5550635376 | 332 | 16328978 | 49183.6687 | 272 | 16328978 | 60033.0074 | |
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 |
|