SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 12 | 178.78 ms | 14.90 ms | 57.02 ms | |
root | wait/io/file/innodb/innodb_data_file | 175 | 44.51 ms | 254.36 us | 3.85 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 27.82 ms | 618.21 us | 2.31 ms | |
root | wait/io/file/sql/binlog | 90 | 18.28 ms | 203.12 us | 16.62 ms | |
root | wait/io/file/sql/io_cache | 48 | 11.99 ms | 249.84 us | 10.76 ms | |
root | wait/io/table/sql/handler | 52 | 2.15 ms | 41.37 us | 801.38 us | |
root | wait/io/file/sql/misc | 1 | 555.79 us | 555.79 us | 555.79 us | |
root | wait/lock/table/sql/handler | 32 | 37.26 us | 1.16 us | 3.88 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.51 us | 2.26 us | 2.87 us |
|