SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 16 | 142.22 ms | 8.89 ms | 26.95 ms | |
root | wait/io/file/innodb/innodb_data_file | 293 | 74.95 ms | 255.80 us | 3.32 ms | |
root | wait/io/file/sql/ERRMSG | 30 | 27.90 ms | 930.04 us | 3.98 ms | |
root | wait/io/table/sql/handler | 156 | 19.73 ms | 126.49 us | 5.36 ms | |
root | wait/io/file/sql/io_cache | 144 | 9.60 ms | 66.68 us | 4.73 ms | |
root | wait/io/file/myisam/kfile | 12 | 4.02 ms | 334.89 us | 3.27 ms | |
root | wait/io/file/csv/metadata | 8 | 3.20 ms | 400.25 us | 1.47 ms | |
root | wait/io/file/myisam/dfile | 18 | 1.94 ms | 107.74 us | 1.83 ms | |
root | wait/io/file/sql/binlog | 100 | 1.06 ms | 10.57 us | 381.33 us | |
root | wait/io/file/csv/data | 46 | 779.29 us | 16.94 us | 464.47 us | |
root | wait/io/file/sql/binlog_index | 2 | 295.42 us | 147.71 us | 293.65 us | |
root | wait/lock/table/sql/handler | 250 | 288.57 us | 1.15 us | 4.36 us |
|