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 | 2158 | 10909098493392 | 5055189216 | 540848300784 | 1352810448 | 686127072576 | 10221618610368 | 8 | 70656 | 8832.0000 | 1450 | 2425856 | 1673.0041 | |
innodb/innodb_data_file | 3991 | 4495921054416 | 1126514664 | 373293976704 | 733746175536 | 69351864384 | 3692823014496 | 1602 | 31358976 | 19574.8914 | 1690 | 63193088 | 37392.3598 | |
innodb/innodb_temp_file | 126 | 672742996464 | 5339229984 | 35003204016 | 0 | 3742280784 | 669000715680 | 0 | 0 | 0.0000 | 54 | 2326528 | 43083.8519 | |
sql/binlog | 405 | 579640866816 | 1431211848 | 36004606176 | 1296174528 | 1288957296 | 577055734992 | 81 | 920 | 11.3580 | 37 | 7414 | 200.3784 | |
sql/binlog_index | 38 | 53739111888 | 1414187016 | 38023076256 | 311074368 | 0 | 53428037520 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 43358004096 | 722633208 | 4173081264 | 23752979712 | 0 | 19605024384 | 36 | 3685233 | 102367.5833 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1806892032 | 361378248 | 1786310064 | 1787612112 | 0 | 19279920 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 94 | 1738113696 | 18490560 | 262785072 | 166474704 | 981759504 | 589879488 | 48 | 2165100 | 45106.2500 | 36 | 2165100 | 60141.6667 | |
myisam/kfile | 14 | 1190501664 | 85035720 | 588314496 | 841197456 | 0 | 349304208 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1170645168 | 78042888 | 1109038128 | 0 | 0 | 1170645168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 341896896 | 113965632 | 303201888 | 303201888 | 0 | 38695008 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 10 | 261851040 | 26185104 | 187394592 | 0 | 0 | 261851040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 24014496 | 12007248 | 14082816 | 0 | 0 | 24014496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15766080 | 5255184 | 11047344 | 0 | 3997488 | 11768592 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|