SELECT * FROM `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 | 3939 | 19.48 s | 4.94 ms | 679.13 ms | 995.10 us | 517.96 ms | 18.96 s | 8 | 69.00 KiB | 8.62 KiB | 2502 | 3.68 MiB | 1.51 KiB | |
innodb/innodb_data_file | 5361 | 9.85 s | 1.84 ms | 564.68 ms | 756.78 ms | 110.04 ms | 8.98 s | 1362 | 26.16 MiB | 19.67 KiB | 2880 | 98.05 MiB | 34.86 KiB | |
sql/binlog | 539 | 1.11 s | 2.06 ms | 27.70 ms | 1.23 ms | 2.02 ms | 1.11 s | 92 | 964 bytes | 10 bytes | 82 | 40.21 KiB | 502 bytes | |
innodb/innodb_temp_file | 90 | 334.86 ms | 3.72 ms | 30.92 ms | 0 ps | 757.82 us | 334.11 ms | 0 | 0 bytes | 0 bytes | 30 | 1.09 MiB | 37.33 KiB | |
sql/binlog_index | 38 | 49.01 ms | 1.29 ms | 33.90 ms | 573.87 us | 0 ps | 48.43 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 75 | 28.39 ms | 378.47 us | 2.34 ms | 18.98 ms | 0 ps | 9.41 ms | 45 | 4.40 MiB | 100.03 KiB | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 73 | 1.94 ms | 26.60 us | 1.38 ms | 40.35 us | 120.86 us | 1.78 ms | 10 | 1.83 KiB | 188 bytes | 34 | 1.42 KiB | 43 bytes | |
sql/casetest | 15 | 1.06 ms | 70.95 us | 963.11 us | 0 ps | 0 ps | 1.06 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 847.62 us | 105.95 us | 487.64 us | 671.11 us | 0 ps | 176.51 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
sql/SDI | 27 | 760.01 us | 28.15 us | 292.16 us | 0 ps | 118.13 us | 641.88 us | 0 | 0 bytes | 0 bytes | 7 | 29.41 KiB | 4.20 KiB | |
mysys/cnf | 5 | 505.12 us | 101.02 us | 485.77 us | 487.21 us | 0 ps | 17.91 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 291.10 us | 97.03 us | 272.86 us | 272.86 us | 0 ps | 18.24 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/misc | 13 | 204.43 us | 15.73 us | 32.07 us | 0 ps | 0 ps | 204.43 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
csv/data | 4 | 202.08 us | 50.52 us | 171.33 us | 0 ps | 0 ps | 202.08 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 40 | 196.43 us | 4.91 us | 20.18 us | 10.85 us | 34.49 us | 151.09 us | 8 | 2.44 KiB | 312 bytes | 6 | 3.67 KiB | 626 bytes | |
sql/pid | 3 | 13.00 us | 4.33 us | 10.37 us | 0 ps | 1.99 us | 11.01 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|