SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 56 | 582.45 ms | 10.40 ms | 69.94 ms | |
root | wait/io/file/sql/io_cache | 237 | 74.95 ms | 316.25 us | 48.33 ms | |
root | wait/io/file/innodb/innodb_data_file | 189 | 53.36 ms | 282.33 us | 2.79 ms | |
root | wait/io/file/sql/ERRMSG | 35 | 23.19 ms | 662.44 us | 2.51 ms | |
root | wait/io/table/sql/handler | 103 | 11.53 ms | 111.90 us | 3.86 ms | |
root | wait/io/file/sql/binlog | 148 | 3.34 ms | 22.60 us | 1.74 ms | |
root | wait/io/file/myisam/kfile | 8 | 603.80 us | 75.47 us | 288.75 us | |
root | wait/io/file/myisam/dfile | 8 | 295.01 us | 36.88 us | 263.66 us | |
root | wait/io/file/sql/binlog_index | 2 | 232.99 us | 116.50 us | 231.64 us | |
root | wait/lock/table/sql/handler | 98 | 148.10 us | 1.51 us | 4.17 us |
|