SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 448 | 727.57 ms | 1.62 ms | 39.51 ms | |
root | wait/io/file/sql/binlog | 104 | 243.31 ms | 2.34 ms | 30.20 ms | |
root | wait/io/file/innodb/innodb_temp_file | 8 | 102.47 ms | 12.81 ms | 35.00 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 25.78 ms | 644.39 us | 4.24 ms | |
root | wait/io/table/sql/handler | 401 | 8.32 ms | 20.74 us | 1.61 ms | |
root | wait/io/file/myisam/kfile | 4 | 761.50 us | 190.38 us | 738.16 us | |
root | wait/io/file/csv/metadata | 4 | 405.68 us | 101.42 us | 326.73 us | |
root | wait/lock/table/sql/handler | 268 | 301.66 us | 1.13 us | 15.80 us | |
root | wait/io/file/sql/binlog_index | 2 | 245.29 us | 122.64 us | 243.49 us | |
root | wait/io/file/csv/data | 2 | 203.59 us | 101.80 us | 195.59 us | |
root | wait/io/file/sql/misc | 3 | 37.07 us | 12.36 us | 13.31 us | |
root | wait/io/file/myisam/dfile | 2 | 12.17 us | 6.08 us | 11.62 us |
|