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 | 2182 | 12.77 s | 5.85 ms | 107.17 ms | 1.18 ms | 359.46 ms | 12.41 s | 8 | 69.00 KiB | 8.62 KiB | 1344 | 1.70 MiB | 1.30 KiB | |
innodb/innodb_data_file | 4934 | 9.36 s | 1.90 ms | 232.77 ms | 236.54 ms | 126.09 ms | 9.00 s | 1487 | 28.11 MiB | 19.36 KiB | 2516 | 85.20 MiB | 34.68 KiB | |
sql/binlog | 467 | 852.62 ms | 1.83 ms | 33.26 ms | 2.40 ms | 3.83 ms | 846.39 ms | 87 | 944 bytes | 11 bytes | 56 | 16.99 KiB | 311 bytes | |
innodb/innodb_temp_file | 151 | 682.83 ms | 4.52 ms | 30.30 ms | 0 ps | 46.33 ms | 636.49 ms | 0 | 0 bytes | 0 bytes | 78 | 2.66 MiB | 34.87 KiB | |
sql/binlog_index | 38 | 51.53 ms | 1.36 ms | 34.47 ms | 1.78 ms | 0 ps | 49.75 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 60 | 31.71 ms | 528.42 us | 3.24 ms | 18.49 ms | 0 ps | 13.21 ms | 36 | 3.52 MiB | 100.20 KiB | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 2.13 ms | 266.76 us | 1.09 ms | 1.55 ms | 0 ps | 581.04 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 1.70 ms | 424.96 us | 1.67 ms | 1.68 ms | 0 ps | 23.47 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 848.98 us | 56.60 us | 786.49 us | 0 ps | 0 ps | 848.98 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 743.25 us | 148.65 us | 719.41 us | 721.41 us | 0 ps | 21.84 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 15 | 310.89 us | 20.73 us | 35.63 us | 0 ps | 0 ps | 310.89 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 295.82 us | 98.61 us | 275.09 us | 275.09 us | 0 ps | 20.73 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
csv/data | 4 | 121.17 us | 30.29 us | 59.65 us | 0 ps | 0 ps | 121.17 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 12.88 us | 4.29 us | 10.22 us | 0 ps | 2.00 us | 10.88 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | |
myisam/dfile | 2 | 9.41 us | 4.71 us | 9.11 us | 0 ps | 0 ps | 9.41 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes |
|