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 | 22172 | 73480106267040 | 3314094432 | 246000175344 | 1671031824 | 2416755149952 | 71061680085264 | 8 | 70656 | 8832.0000 | 15019 | 26669568 | 1775.7220 | |
innodb/innodb_data_file | 12149 | 27514412876016 | 2264746968 | 216960589296 | 365179885488 | 588052696176 | 26561180294352 | 1655 | 32227328 | 19472.7057 | 6180 | 222511104 | 36005.0330 | |
sql/binlog | 1586 | 5944272941904 | 3747965232 | 106771149936 | 2065234512 | 16027122144 | 5926180585248 | 162 | 1244 | 7.6790 | 468 | 257050 | 549.2521 | |
innodb/innodb_temp_file | 175 | 821205162096 | 4692600792 | 135545000976 | 0 | 140830674864 | 680374487232 | 0 | 0 | 0.0000 | 97 | 3424256 | 35301.6082 | |
sql/ERRMSG | 95 | 64384691712 | 677733408 | 8760886992 | 38276653008 | 0 | 26108038704 | 57 | 5827242 | 102232.3158 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 50744156496 | 1335372456 | 29378174496 | 2069432112 | 0 | 48674724384 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 430 | 48048264528 | 111740112 | 23162329344 | 1074129936 | 8156940528 | 38817194064 | 226 | 9878399 | 43709.7301 | 164 | 9878399 | 60234.1402 | |
myisam/dfile | 8318 | 5249775168 | 630960 | 360643008 | 5014204272 | 0 | 235570896 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 4521645744 | 1130411304 | 2411119920 | 2068333344 | 0 | 2453312400 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 2101738848 | 262717224 | 1795027344 | 0 | 0 | 2101738848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 1860349392 | 116271672 | 815819136 | 1808043600 | 0 | 52305792 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 724409664 | 48293784 | 662813712 | 0 | 0 | 724409664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 623355216 | 124670832 | 603087408 | 604717344 | 0 | 18637872 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290909520 | 96969840 | 279057504 | 279057504 | 0 | 11852016 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 72297456 | 36148728 | 57650736 | 0 | 0 | 72297456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 19618368 | 6539280 | 15637248 | 0 | 2952048 | 16666320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|