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 | 220 | 1948242706608 | 8855648472 | 974415374064 | 1736898240 | 15382163808 | 1931123644560 | 8 | 70656 | 8832.0000 | 126 | 125440 | 995.5556 | |
innodb/innodb_data_file | 1679 | 1137298687008 | 677366448 | 258297297456 | 244020503232 | 28576781376 | 864701402400 | 1186 | 24543232 | 20694.1248 | 294 | 19316736 | 65703.1837 | |
innodb/innodb_temp_file | 93 | 433075330512 | 4656723984 | 33990798864 | 0 | 2661371856 | 430413958656 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | |
sql/binlog_index | 38 | 59304219216 | 1560637320 | 36945909792 | 795048672 | 0 | 58509170544 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 81 | 37778362512 | 466399296 | 17576517024 | 990259248 | 77371008 | 36710732256 | 17 | 664 | 39.0588 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 40 | 20370846672 | 509271048 | 2149576176 | 12972662208 | 0 | 7398184464 | 24 | 2466162 | 102756.7500 | 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 | 1 | 15630384 | 15630384 | 15630384 | 0 | 0 | 15630384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|