SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 110 | 1.08 s | 9.82 ms | 60.77 ms | |
root | wait/io/table/sql/handler | 266582 | 410.97 ms | 1.54 us | 56.43 ms | |
root | wait/io/file/innodb/innodb_data_file | 676 | 269.85 ms | 399.19 us | 19.58 ms | |
root | wait/io/file/sql/io_cache | 1625 | 231.92 ms | 142.72 us | 174.45 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 49.45 ms | 899.02 us | 7.53 ms | |
root | wait/io/file/csv/metadata | 8 | 10.58 ms | 1.32 ms | 9.00 ms | |
root | wait/io/file/sql/binlog | 458 | 5.20 ms | 11.36 us | 1.87 ms | |
root | wait/io/file/myisam/kfile | 12 | 1.08 ms | 90.30 us | 552.61 us | |
root | wait/lock/table/sql/handler | 770 | 1.04 ms | 1.35 us | 16.39 us | |
root | wait/io/file/csv/data | 4 | 700.35 us | 175.09 us | 574.07 us | |
root | wait/lock/metadata/sql/mdl | 1 | 344.65 us | 344.65 us | 344.65 us | |
root | wait/io/file/myisam/dfile | 7 | 72.87 us | 10.41 us | 29.82 us | |
root | wait/io/file/sql/binlog_index | 2 | 3.98 us | 1.99 us | 2.25 us |
|