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 | 625 | 2966053914384 | 4745686176 | 31704223056 | 1212111648 | 53580349152 | 2911261453584 | 8 | 70656 | 8832.0000 | 368 | 301056 | 818.0870 | |
innodb/innodb_data_file | 2377 | 1930725743760 | 812253024 | 195974418288 | 194978541120 | 24209886624 | 1711537316016 | 1324 | 26804224 | 20244.8822 | 743 | 33472512 | 45050.4872 | |
innodb/innodb_temp_file | 666 | 1326869598912 | 1992296592 | 283298567376 | 0 | 517547667648 | 809321931264 | 0 | 0 | 0.0000 | 583 | 11714560 | 20093.5849 | |
sql/binlog_index | 38 | 55336979280 | 1456236144 | 28889379024 | 1524857664 | 0 | 53812121616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 269 | 40133075136 | 149193528 | 20123708352 | 2990693904 | 20910912 | 37121470320 | 64 | 852 | 13.3125 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 45 | 24794667216 | 550992552 | 2518664016 | 12371046336 | 0 | 12423620880 | 27 | 2770656 | 102616.8889 | 0 | 0 | 0.0000 | |
sql/io_cache | 194 | 13107593136 | 67564728 | 3759809856 | 742149936 | 3864106224 | 8501336976 | 84 | 4701360 | 55968.5714 | 80 | 4701360 | 58767.0000 | |
csv/metadata | 4 | 3376700976 | 844175112 | 1907104848 | 1452371184 | 0 | 1924329792 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 895852848 | 59723400 | 813221904 | 0 | 0 | 895852848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 423623904 | 84724728 | 405869904 | 407072160 | 0 | 16551744 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 305534064 | 101844600 | 288990768 | 288990768 | 0 | 16543296 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 18081888 | 9040944 | 11591184 | 0 | 0 | 18081888 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12032064 | 4010688 | 9714672 | 0 | 1706496 | 10325568 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 4783152 | 4783152 | 4783152 | 0 | 0 | 4783152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|