SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 24 | 211.52 ms | 8.81 ms | 23.80 ms | |
root | wait/io/file/innodb/innodb_data_file | 289 | 79.99 ms | 276.79 us | 2.27 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 41.84 ms | 836.86 us | 7.20 ms | |
root | wait/io/file/sql/binlog | 170 | 33.54 ms | 197.27 us | 16.07 ms | |
root | wait/io/file/sql/io_cache | 343 | 20.85 ms | 60.80 us | 11.77 ms | |
root | wait/io/table/sql/handler | 96 | 11.57 ms | 120.49 us | 4.65 ms | |
root | wait/io/file/csv/metadata | 4 | 10.89 ms | 2.72 ms | 10.66 ms | |
root | wait/io/file/csv/data | 6 | 430.51 us | 71.75 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 | 143 | 144.94 us | 1.01 us | 2.74 us | |
root | wait/lock/metadata/sql/mdl | 1 | 3.34 us | 3.34 us | 3.34 us |
|