SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 215 | 146.38 ms | 680.83 us | 33.40 ms | |
root | wait/io/file/sql/binlog | 78 | 41.51 ms | 532.14 us | 13.75 ms | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 30.30 ms | 15.15 ms | 30.27 ms | |
root | wait/io/file/sql/ERRMSG | 30 | 21.92 ms | 730.66 us | 3.11 ms | |
root | wait/io/table/sql/handler | 971 | 10.38 ms | 10.69 us | 3.87 ms | |
root | wait/io/file/sql/io_cache | 70 | 2.87 ms | 40.97 us | 922.17 us | |
root | wait/io/file/csv/metadata | 4 | 552.86 us | 138.22 us | 445.46 us | |
root | wait/lock/table/sql/handler | 95 | 104.52 us | 1.10 us | 4.66 us | |
root | wait/io/file/sql/misc | 2 | 30.49 us | 15.25 us | 19.21 us | |
root | wait/io/file/csv/data | 6 | 26.78 us | 4.46 us | 9.05 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.13 us | 2.56 us | 3.00 us |
|