SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 294 | 933.82 ms | 3.18 ms | 30.95 ms | |
root | wait/io/file/innodb/innodb_data_file | 759 | 598.65 ms | 788.73 us | 29.98 ms | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 51.59 ms | 8.60 ms | 21.68 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 33.76 ms | 482.23 us | 2.85 ms | |
root | wait/io/table/sql/handler | 310 | 6.41 ms | 20.67 us | 926.65 us | |
root | wait/io/file/csv/metadata | 8 | 1.01 ms | 125.97 us | 581.87 us | |
root | wait/io/file/myisam/kfile | 9 | 539.72 us | 59.97 us | 263.75 us | |
root | wait/io/file/myisam/dfile | 7 | 365.82 us | 52.26 us | 315.66 us | |
root | wait/io/file/csv/data | 4 | 337.40 us | 84.35 us | 294.93 us | |
root | wait/lock/table/sql/handler | 198 | 222.40 us | 1.12 us | 13.15 us | |
root | wait/io/file/sql/binlog_index | 2 | 151.40 us | 75.70 us | 149.81 us | |
root | wait/io/file/sql/misc | 11 | 122.98 us | 11.18 us | 24.11 us |
|