SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 675 | 642.84 ms | 952.36 us | 293.33 ms | |
root | wait/io/table/sql/handler | 90592 | 504.55 ms | 5.57 us | 294.66 ms | |
root | wait/io/file/sql/binlog | 260 | 59.61 ms | 229.27 us | 15.34 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 41.29 ms | 917.59 us | 4.27 ms | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 20.95 ms | 10.48 ms | 20.92 ms | |
root | wait/io/file/myisam/dfile | 8310 | 8.05 ms | 968.09 ns | 1.24 ms | |
root | wait/io/file/myisam/kfile | 16 | 3.82 ms | 238.72 us | 1.66 ms | |
root | wait/io/file/sql/io_cache | 70 | 1.67 ms | 23.87 us | 268.39 us | |
root | wait/io/file/csv/metadata | 4 | 1.00 ms | 251.16 us | 839.19 us | |
root | wait/lock/table/sql/handler | 715 | 708.36 us | 990.53 ns | 6.17 us | |
root | wait/io/file/csv/data | 8 | 431.38 us | 53.92 us | 388.73 us | |
root | wait/io/file/sql/misc | 2 | 21.31 us | 10.65 us | 10.69 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.39 us | 2.20 us | 2.82 us |
|