SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 76 | 798.46 ms | 10.51 ms | 60.65 ms | |
root | wait/io/table/sql/handler | 495428 | 290.49 ms | 586.08 ns | 5.97 ms | |
root | wait/io/file/innodb/innodb_data_file | 618 | 236.73 ms | 383.05 us | 21.91 ms | |
root | wait/io/file/sql/io_cache | 358 | 120.76 ms | 337.32 us | 99.46 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 48.49 ms | 692.77 us | 3.37 ms | |
root | wait/io/file/sql/binlog | 360 | 37.48 ms | 104.12 us | 17.76 ms | |
root | wait/io/file/csv/metadata | 8 | 4.72 ms | 589.43 us | 2.29 ms | |
root | wait/io/file/myisam/dfile | 27 | 4.49 ms | 166.16 us | 1.89 ms | |
root | wait/io/file/myisam/kfile | 16 | 4.11 ms | 256.71 us | 2.54 ms | |
root | wait/io/file/csv/data | 49 | 3.09 ms | 63.01 us | 2.70 ms | |
root | wait/lock/table/sql/handler | 603 | 802.24 us | 1.33 us | 46.79 us | |
root | wait/io/file/sql/binlog_index | 2 | 143.58 us | 71.79 us | 142.25 us | |
root | wait/io/file/sql/misc | 1 | 12.69 us | 12.69 us | 12.69 us |
|