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 | 1450 | 7.85 s | 5.41 ms | 110.48 ms | 1.05 ms | 221.94 ms | 7.62 s | 8 | 69.00 KiB | 8.62 KiB | 902 | 1.20 MiB | 1.37 KiB | |
innodb/innodb_data_file | 3231 | 4.83 s | 1.50 ms | 217.11 ms | 200.89 ms | 41.25 ms | 4.59 s | 1337 | 25.77 MiB | 19.73 KiB | 1264 | 47.80 MiB | 38.72 KiB | |
sql/binlog | 335 | 523.22 ms | 1.56 ms | 36.22 ms | 695.25 us | 2.05 ms | 520.48 ms | 65 | 856 bytes | 13 bytes | 34 | 10.34 KiB | 312 bytes | |
innodb/innodb_temp_file | 96 | 387.06 ms | 4.03 ms | 33.07 ms | 0 ps | 1.07 ms | 385.99 ms | 0 | 0 bytes | 0 bytes | 34 | 1.28 MiB | 38.59 KiB | |
sql/binlog_index | 38 | 48.49 ms | 1.28 ms | 33.23 ms | 500.76 us | 0 ps | 47.99 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 85 | 30.45 ms | 358.19 us | 1.66 ms | 22.56 ms | 0 ps | 7.88 ms | 51 | 4.98 MiB | 99.91 KiB | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 1.06 ms | 70.61 us | 941.85 us | 0 ps | 0 ps | 1.06 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 426.86 us | 85.37 us | 401.12 us | 402.87 us | 0 ps | 23.99 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 259.04 us | 86.34 us | 240.44 us | 240.44 us | 0 ps | 18.59 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/misc | 9 | 158.20 us | 17.58 us | 67.52 us | 0 ps | 0 ps | 158.20 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 14.38 us | 4.79 us | 11.50 us | 0 ps | 2.22 us | 12.15 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|