SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 22 | 777.35 ms | 35.33 ms | 572.29 ms | |
root | wait/io/file/innodb/innodb_data_file | 184 | 54.75 ms | 297.56 us | 2.24 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 37.65 ms | 836.58 us | 5.38 ms | |
root | wait/io/table/sql/handler | 3161 | 17.53 ms | 5.55 us | 4.35 ms | |
root | wait/io/file/sql/binlog | 134 | 16.33 ms | 121.85 us | 13.29 ms | |
root | wait/io/file/csv/data | 6 | 865.39 us | 144.23 us | 847.14 us | |
root | wait/io/file/sql/misc | 1 | 274.60 us | 274.60 us | 274.60 us | |
root | wait/io/file/csv/metadata | 4 | 227.00 us | 56.75 us | 168.69 us | |
root | wait/lock/table/sql/handler | 79 | 87.61 us | 1.11 us | 4.62 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.91 us | 2.45 us | 3.21 us |
|