SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 84 | 722.47 ms | 8.60 ms | 26.84 ms | |
root | wait/io/file/innodb/innodb_data_file | 451 | 248.76 ms | 551.58 us | 30.46 ms | |
root | wait/io/file/sql/io_cache | 1403 | 154.67 ms | 110.24 us | 24.16 ms | |
root | wait/io/file/sql/binlog | 442 | 152.54 ms | 345.12 us | 19.03 ms | |
root | wait/io/file/sql/ERRMSG | 65 | 53.52 ms | 823.44 us | 7.20 ms | |
root | wait/io/table/sql/handler | 163 | 29.37 ms | 180.17 us | 11.29 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/lock/table/sql/handler | 287 | 333.83 us | 1.16 us | 14.33 us | |
root | wait/io/file/sql/binlog_index | 2 | 325.52 us | 162.76 us | 323.78 us | |
root | wait/io/file/sql/misc | 3 | 56.80 us | 18.93 us | 32.36 us |
|