SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 10 | 136.39 ms | 13.64 ms | 35.67 ms | |
root | wait/io/file/innodb/innodb_data_file | 123 | 64.15 ms | 521.56 us | 20.65 ms | |
root | wait/io/table/sql/handler | 505 | 15.66 ms | 31.02 us | 9.57 ms | |
root | wait/io/file/sql/ERRMSG | 20 | 10.77 ms | 538.44 us | 2.92 ms | |
root | wait/io/file/sql/io_cache | 188 | 10.39 ms | 55.26 us | 5.94 ms | |
root | wait/io/file/csv/metadata | 8 | 3.17 ms | 396.61 us | 1.98 ms | |
root | wait/io/file/sql/binlog | 28 | 2.11 ms | 75.41 us | 332.77 us | |
root | wait/lock/table/sql/handler | 46 | 87.65 us | 1.91 us | 31.46 us | |
root | wait/io/file/csv/data | 4 | 59.93 us | 14.98 us | 25.19 us | |
root | wait/lock/metadata/sql/mdl | 2 | 31.20 us | 15.60 us | 19.35 us | |
root | wait/io/file/sql/binlog_index | 2 | 15.19 us | 7.59 us | 10.07 us |
|