SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 454 | 728.60 ms | 1.60 ms | 39.51 ms | |
root | wait/io/file/sql/binlog | 164 | 243.61 ms | 1.49 ms | 30.20 ms | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 127.34 ms | 12.73 ms | 35.00 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 29.76 ms | 661.23 us | 4.24 ms | |
root | wait/io/table/sql/handler | 636 | 12.11 ms | 19.03 us | 1.67 ms | |
root | wait/io/file/myisam/kfile | 16 | 5.23 ms | 327.16 us | 2.65 ms | |
root | wait/io/file/myisam/dfile | 62 | 2.18 ms | 35.11 us | 1.65 ms | |
root | wait/lock/table/sql/handler | 401 | 482.35 us | 1.20 us | 15.80 us | |
root | wait/io/file/csv/metadata | 4 | 405.68 us | 101.42 us | 326.73 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 |
|