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 | 470 | 3235638560352 | 6884337240 | 974415374064 | 1736898240 | 39749362224 | 3194152299888 | 8 | 70656 | 8832.0000 | 274 | 237056 | 865.1679 | |
innodb/innodb_data_file | 2116 | 2014709710464 | 952131048 | 258297297456 | 258729520896 | 39036313008 | 1716943876560 | 1229 | 25247744 | 20543.3230 | 621 | 29507584 | 47516.2383 | |
innodb/innodb_temp_file | 289 | 630626333568 | 2182097808 | 63491748144 | 0 | 68106444912 | 562519888656 | 0 | 0 | 0.0000 | 221 | 4800512 | 21721.7738 | |
sql/binlog_index | 38 | 59304219216 | 1560637320 | 36945909792 | 795048672 | 0 | 58509170544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 179 | 51670794912 | 288663408 | 17576517024 | 1276289520 | 260898000 | 50133607392 | 41 | 760 | 18.5366 | 4 | 420 | 105.0000 | |
sql/ERRMSG | 50 | 24605985888 | 492119496 | 2149576176 | 15999712608 | 0 | 8606273280 | 30 | 3077986 | 102599.5333 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 986604432 | 65773488 | 922901232 | 0 | 0 | 986604432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 733137504 | 146627448 | 699411504 | 702467568 | 0 | 30669936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 316897680 | 105632472 | 302922576 | 302922576 | 0 | 13975104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 57048288 | 19015920 | 43457040 | 0 | 10101168 | 46947120 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 26403168 | 13201584 | 15630384 | 0 | 0 | 26403168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|