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 | 796 | 5.46 s | 6.86 ms | 909.51 ms | 1.41 ms | 46.34 ms | 5.41 s | 8 | 69.00 KiB | 8.62 KiB | 463 | 454.00 KiB | 1004 bytes | |
innodb/innodb_data_file | 2946 | 4.20 s | 1.42 ms | 270.53 ms | 320.87 ms | 57.82 ms | 3.82 s | 1475 | 27.92 MiB | 19.38 KiB | 1001 | 39.11 MiB | 40.01 KiB | |
innodb/innodb_temp_file | 259 | 1.29 s | 4.97 ms | 127.71 ms | 0 ps | 243.47 ms | 1.04 s | 0 | 0 bytes | 0 bytes | 164 | 5.38 MiB | 33.56 KiB | |
sql/binlog | 308 | 193.02 ms | 626.68 us | 23.50 ms | 1.46 ms | 2.88 ms | 188.67 ms | 70 | 1023 bytes | 15 bytes | 12 | 2.88 KiB | 246 bytes | |
sql/ERRMSG | 70 | 54.57 ms | 779.59 us | 3.33 ms | 28.00 ms | 0 ps | 26.57 ms | 42 | 4.09 MiB | 99.82 KiB | 0 | 0 bytes | 0 bytes | |
sql/binlog_index | 38 | 51.80 ms | 1.36 ms | 29.99 ms | 1.05 ms | 0 ps | 50.75 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/io_cache | 74 | 25.83 ms | 349.06 us | 24.18 ms | 165.17 us | 1.11 ms | 24.55 ms | 32 | 1.76 MiB | 56.38 KiB | 32 | 1.76 MiB | 56.38 KiB | |
mysys/cnf | 5 | 2.58 ms | 516.60 us | 2.56 ms | 2.56 ms | 0 ps | 18.47 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 942.52 us | 235.63 us | 898.49 us | 904.19 us | 0 ps | 38.34 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 840.50 us | 56.03 us | 776.59 us | 0 ps | 0 ps | 840.50 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 232 | 470.59 us | 2.03 us | 306.92 us | 380.44 us | 0 ps | 90.15 us | 150 | 8.71 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 303.35 us | 101.12 us | 280.92 us | 280.92 us | 0 ps | 22.43 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/misc | 6 | 95.04 us | 15.84 us | 31.95 us | 0 ps | 0 ps | 95.04 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 46.75 us | 15.58 us | 36.61 us | 0 ps | 7.30 us | 39.45 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|