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 | 416 | 2945616142656 | 7080807888 | 974415374064 | 1736898240 | 30835579104 | 2913043665312 | 8 | 70656 | 8832.0000 | 241 | 211456 | 877.4108 | |
innodb/innodb_data_file | 2065 | 1898725563504 | 919479528 | 258297297456 | 258407793600 | 38199728688 | 1602118041216 | 1228 | 25231360 | 20546.7101 | 581 | 28262400 | 48644.4062 | |
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 | 147 | 51498353280 | 350328792 | 17576517024 | 1252640400 | 260898000 | 49984814880 | 33 | 728 | 22.0606 | 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 |
|