SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/ERRMSG | 25 | 91.67 ms | 3.67 ms | 72.66 ms | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 48.08 ms | 8.01 ms | 22.21 ms | |
root | wait/io/file/innodb/innodb_data_file | 189 | 45.00 ms | 238.07 us | 3.45 ms | |
root | wait/io/file/sql/binlog | 28 | 37.09 ms | 1.32 ms | 21.01 ms | |
root | wait/io/file/sql/io_cache | 108 | 5.54 ms | 51.34 us | 2.09 ms | |
root | wait/io/table/sql/handler | 78 | 5.07 ms | 65.00 us | 1.06 ms | |
root | wait/io/file/sql/binlog_index | 2 | 153.68 us | 76.84 us | 151.80 us | |
root | wait/lock/table/sql/handler | 59 | 62.88 us | 1.07 us | 3.46 us | |
root | wait/io/file/sql/misc | 2 | 23.49 us | 11.74 us | 13.87 us |
|