SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 62 | 531.55 ms | 8.57 ms | 23.80 ms | |
root | wait/io/file/innodb/innodb_data_file | 398 | 188.86 ms | 474.52 us | 30.46 ms | |
root | wait/io/file/sql/io_cache | 1145 | 143.90 ms | 125.68 us | 24.16 ms | |
root | wait/io/file/sql/binlog | 318 | 117.46 ms | 369.38 us | 16.07 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 49.19 ms | 819.77 us | 7.20 ms | |
root | wait/io/table/sql/handler | 145 | 17.60 ms | 121.40 us | 4.65 ms | |
root | wait/io/file/csv/metadata | 8 | 11.13 ms | 1.39 ms | 10.66 ms | |
root | wait/lock/metadata/sql/mdl | 2 | 7.51 ms | 3.76 ms | 7.51 ms | |
root | wait/io/file/csv/data | 15 | 866.61 us | 57.77 us | 400.17 us | |
root | wait/io/file/sql/binlog_index | 2 | 325.52 us | 162.76 us | 323.78 us | |
root | wait/lock/table/sql/handler | 250 | 282.11 us | 1.13 us | 14.33 us | |
root | wait/io/file/sql/misc | 3 | 56.80 us | 18.93 us | 32.36 us |
|