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 | 1070 | 7.56 s | 7.07 ms | 762.57 ms | 1.54 ms | 262.07 ms | 7.30 s | 8 | 69.00 KiB | 8.62 KiB | 631 | 608.00 KiB | 987 bytes | |
innodb/innodb_data_file | 3413 | 6.55 s | 1.92 ms | 642.42 ms | 974.94 ms | 79.19 ms | 5.50 s | 1465 | 27.77 MiB | 19.41 KiB | 1348 | 49.42 MiB | 37.54 KiB | |
innodb/innodb_temp_file | 117 | 577.96 ms | 4.94 ms | 41.03 ms | 0 ps | 3.29 ms | 574.67 ms | 0 | 0 bytes | 0 bytes | 48 | 1.94 MiB | 41.33 KiB | |
sql/binlog | 331 | 356.32 ms | 1.08 ms | 30.32 ms | 1.54 ms | 3.08 ms | 351.70 ms | 70 | 876 bytes | 13 bytes | 22 | 5.55 KiB | 258 bytes | |
sql/ERRMSG | 75 | 54.45 ms | 726.05 us | 6.16 ms | 28.49 ms | 0 ps | 25.96 ms | 45 | 4.39 MiB | 99.98 KiB | 0 | 0 bytes | 0 bytes | |
sql/binlog_index | 38 | 46.11 ms | 1.21 ms | 24.08 ms | 2.13 ms | 0 ps | 43.98 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 2.42 ms | 604.12 us | 2.36 ms | 2.37 ms | 0 ps | 49.61 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 1.71 ms | 341.44 us | 1.69 ms | 1.69 ms | 0 ps | 14.21 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 1.43 ms | 178.63 us | 552.33 us | 1.09 ms | 0 ps | 340.34 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 819.02 us | 54.60 us | 749.45 us | 0 ps | 0 ps | 819.02 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 156 | 459.17 us | 2.94 us | 365.11 us | 395.44 us | 0 ps | 63.74 us | 100 | 5.81 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | |
csv/data | 4 | 358.40 us | 89.60 us | 273.62 us | 0 ps | 0 ps | 358.40 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 281.67 us | 93.89 us | 268.74 us | 268.74 us | 0 ps | 12.93 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/misc | 6 | 119.57 us | 19.93 us | 31.54 us | 0 ps | 0 ps | 119.57 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 47.51 us | 15.84 us | 37.28 us | 0 ps | 7.90 us | 39.60 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|