SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 20 | 192.26 ms | 9.61 ms | 39.48 ms | |
root | wait/io/file/sql/io_cache | 400 | 67.22 ms | 168.06 us | 29.65 ms | |
root | wait/io/file/innodb/innodb_data_file | 210 | 56.82 ms | 270.58 us | 2.63 ms | |
root | wait/io/file/sql/binlog | 76 | 37.39 ms | 492.02 us | 22.23 ms | |
root | wait/io/file/sql/ERRMSG | 35 | 30.18 ms | 862.28 us | 4.21 ms | |
root | wait/io/table/sql/handler | 312 | 13.01 ms | 41.70 us | 4.08 ms | |
root | wait/io/file/csv/metadata | 4 | 505.76 us | 126.44 us | 459.21 us | |
root | wait/io/file/sql/binlog_index | 2 | 190.76 us | 95.38 us | 189.05 us | |
root | wait/lock/table/sql/handler | 85 | 101.94 us | 1.20 us | 14.74 us | |
root | wait/io/file/csv/data | 9 | 65.03 us | 7.23 us | 20.04 us | |
root | wait/io/file/sql/misc | 2 | 23.37 us | 11.69 us | 12.61 us |
|