SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 355 | 109.14 ms | 307.43 us | 2.84 ms | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 93.07 ms | 15.51 ms | 36.19 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 39.77 ms | 723.02 us | 3.37 ms | |
root | wait/io/table/sql/handler | 889 | 29.18 ms | 32.82 us | 6.12 ms | |
root | wait/io/file/sql/binlog | 200 | 3.22 ms | 16.10 us | 1.95 ms | |
root | wait/io/file/sql/io_cache | 32 | 3.04 ms | 94.91 us | 1.60 ms | |
root | wait/io/file/csv/metadata | 8 | 1.53 ms | 190.84 us | 718.93 us | |
root | wait/io/file/myisam/kfile | 4 | 710.67 us | 177.67 us | 646.67 us | |
root | wait/lock/table/sql/handler | 346 | 352.72 us | 1.02 us | 12.42 us | |
root | wait/io/file/csv/data | 8 | 77.26 us | 9.66 us | 36.73 us | |
root | wait/io/file/myisam/dfile | 5 | 48.47 us | 9.69 us | 30.52 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.34 us | 2.17 us | 2.53 us |
|