SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 449 | 727.93 ms | 1.62 ms | 39.51 ms | |
root | wait/io/file/sql/binlog | 144 | 243.50 ms | 1.69 ms | 30.20 ms | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 127.34 ms | 12.73 ms | 35.00 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 29.76 ms | 661.23 us | 4.24 ms | |
root | wait/io/table/sql/handler | 587 | 10.28 ms | 17.51 us | 1.61 ms | |
root | wait/io/file/myisam/kfile | 16 | 5.23 ms | 327.16 us | 2.65 ms | |
root | wait/io/file/myisam/dfile | 36 | 516.94 us | 14.36 us | 346.38 us | |
root | wait/lock/table/sql/handler | 364 | 437.23 us | 1.20 us | 15.80 us | |
root | wait/io/file/csv/metadata | 4 | 405.68 us | 101.42 us | 326.73 us | |
root | wait/io/file/sql/binlog_index | 2 | 245.29 us | 122.64 us | 243.49 us | |
root | wait/io/file/csv/data | 2 | 203.59 us | 101.80 us | 195.59 us | |
root | wait/io/file/sql/misc | 3 | 37.07 us | 12.36 us | 13.31 us |
|