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 | 165.77 ms | 10.36 ms | 30.36 ms | |
root | wait/io/file/innodb/innodb_data_file | 253 | 164.86 ms | 651.62 us | 52.00 ms | |
root | wait/io/file/sql/binlog | 184 | 84.00 ms | 456.50 us | 26.33 ms | |
root | wait/io/table/sql/handler | 561 | 33.17 ms | 59.13 us | 13.84 ms | |
root | wait/io/file/sql/binlog_index | 2 | 23.89 ms | 11.95 ms | 23.89 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 23.04 ms | 460.83 us | 3.11 ms | |
root | wait/io/file/sql/io_cache | 112 | 3.44 ms | 30.73 us | 761.32 us | |
root | wait/io/file/myisam/kfile | 4 | 580.11 us | 145.03 us | 564.84 us | |
root | wait/lock/table/sql/handler | 209 | 245.39 us | 1.17 us | 13.78 us | |
root | wait/io/file/myisam/dfile | 28 | 236.97 us | 8.46 us | 203.96 us | |
root | wait/io/file/sql/misc | 3 | 66.00 us | 22.00 us | 50.56 us |
|