SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 4 | 41.92 ms | 10.48 ms | 25.34 ms | |
root | wait/io/file/innodb/innodb_data_file | 78 | 24.15 ms | 309.57 us | 2.63 ms | |
root | wait/io/file/sql/ERRMSG | 15 | 11.76 ms | 784.08 us | 3.17 ms | |
root | wait/io/file/sql/io_cache | 94 | 1.70 ms | 18.09 us | 100.22 us | |
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/io/file/sql/binlog | 4 | 156.98 us | 39.25 us | 127.24 us | |
root | wait/io/file/csv/data | 7 | 56.30 us | 8.04 us | 20.04 us | |
root | wait/lock/table/sql/handler | 5 | 6.86 us | 1.37 us | 3.08 us |
|