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 | 716 | 4400663649360 | 6146178192 | 263690719248 | 1244340768 | 681292760016 | 3718126548576 | 8 | 70656 | 8832.0000 | 424 | 350720 | 827.1698 | |
innodb/innodb_data_file | 2740 | 2202788774736 | 803937288 | 219411566352 | 382831172064 | 25517641776 | 1794439960896 | 1458 | 28999680 | 19890.0412 | 958 | 40288256 | 42054.5470 | |
innodb/innodb_temp_file | 126 | 1051329043248 | 8343881040 | 433177047072 | 0 | 163448664720 | 887880378528 | 0 | 0 | 0.0000 | 58 | 2129920 | 36722.7586 | |
sql/ERRMSG | 50 | 300127498704 | 6002549784 | 273601399104 | 13457123856 | 0 | 286670374848 | 30 | 3069590 | 102319.6667 | 0 | 0 | 0.0000 | |
sql/binlog | 91 | 73495386096 | 807641472 | 28166447232 | 1028213472 | 478258176 | 71988914448 | 19 | 672 | 35.3684 | 4 | 429 | 107.2500 | |
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/io_cache | 90 | 4188376896 | 46537392 | 2408982576 | 360368976 | 976435152 | 2851572768 | 44 | 2169224 | 49300.5455 | 36 | 2169224 | 60256.2222 | |
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 | 4 | 384821184 | 96205296 | 206629632 | 0 | 0 | 384821184 | 0 | 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 | 4 | 52442016 | 13110504 | 33705408 | 0 | 0 | 52442016 | 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 |
|