SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 329 | 586.98 ms | 1.78 ms | 43.27 ms | |
root | wait/io/file/sql/binlog | 98 | 268.47 ms | 2.74 ms | 22.58 ms | |
root | wait/io/file/sql/ERRMSG | 20 | 33.60 ms | 1.68 ms | 6.62 ms | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 27.32 ms | 13.66 ms | 27.29 ms | |
root | wait/io/table/sql/handler | 593 | 18.50 ms | 31.20 us | 4.30 ms | |
root | wait/io/file/sql/io_cache | 66 | 2.42 ms | 36.70 us | 1.31 ms | |
root | wait/io/file/csv/metadata | 8 | 788.94 us | 98.62 us | 372.77 us | |
root | wait/io/file/csv/data | 4 | 251.28 us | 62.82 us | 212.20 us | |
root | wait/lock/table/sql/handler | 224 | 241.58 us | 1.08 us | 13.77 us | |
root | wait/io/file/sql/misc | 2 | 22.40 us | 11.20 us | 12.38 us | |
root | wait/io/file/sql/binlog_index | 2 | 12.02 us | 6.01 us | 10.18 us |
|