SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1062076 | 585.33 ms | 550.97 ns | 2.84 ms | |
root | wait/io/file/innodb/innodb_temp_file | 16 | 162.59 ms | 10.16 ms | 26.26 ms | |
root | wait/io/file/innodb/innodb_data_file | 459 | 102.74 ms | 223.83 us | 2.72 ms | |
root | wait/io/file/sql/io_cache | 338 | 85.15 ms | 251.92 us | 31.25 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 32.32 ms | 807.99 us | 7.88 ms | |
root | wait/io/file/sql/binlog | 700 | 17.83 ms | 25.47 us | 6.23 ms | |
root | wait/io/file/csv/metadata | 8 | 11.12 ms | 1.39 ms | 9.45 ms | |
root | wait/io/file/myisam/kfile | 4 | 2.42 ms | 603.92 us | 2.39 ms | |
root | wait/io/file/csv/data | 4 | 1.35 ms | 337.67 us | 1.31 ms | |
root | wait/lock/table/sql/handler | 170 | 186.58 us | 1.10 us | 11.80 us | |
root | wait/io/file/myisam/dfile | 2 | 10.61 us | 5.30 us | 10.06 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.46 us | 2.73 us | 3.43 us |
|