SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 60 | 661.55 ms | 11.03 ms | 42.28 ms | |
root | wait/io/file/sql/io_cache | 779 | 434.22 ms | 557.41 us | 195.59 ms | |
root | wait/io/file/innodb/innodb_data_file | 351 | 106.27 ms | 302.75 us | 9.34 ms | |
root | wait/io/file/sql/binlog | 410 | 53.34 ms | 130.11 us | 19.12 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 28.50 ms | 475.01 us | 2.82 ms | |
root | wait/io/table/sql/handler | 770 | 19.65 ms | 25.52 us | 3.24 ms | |
root | wait/io/file/csv/metadata | 4 | 1.88 ms | 469.43 us | 1.77 ms | |
root | wait/lock/table/sql/handler | 382 | 378.99 us | 992.11 ns | 14.47 us | |
root | wait/io/file/sql/misc | 3 | 40.91 us | 13.64 us | 14.54 us | |
root | wait/io/file/csv/data | 2 | 29.14 us | 14.57 us | 22.68 us | |
root | wait/io/file/sql/binlog_index | 2 | 7.03 us | 3.52 us | 4.55 us |
|