SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 28 | 352.40 ms | 12.59 ms | 50.09 ms | |
root | wait/io/file/sql/io_cache | 239 | 180.30 ms | 754.40 us | 99.79 ms | |
root | wait/io/file/innodb/innodb_data_file | 180 | 142.44 ms | 791.33 us | 61.99 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 51.67 ms | 939.38 us | 5.60 ms | |
root | wait/io/table/sql/handler | 147 | 11.79 ms | 80.21 us | 4.42 ms | |
root | wait/io/file/sql/binlog | 140 | 1.69 ms | 12.08 us | 522.83 us | |
root | wait/io/file/csv/data | 81 | 1.27 ms | 15.64 us | 557.41 us | |
root | wait/io/file/csv/metadata | 8 | 654.10 us | 81.76 us | 262.48 us | |
root | wait/lock/table/sql/handler | 122 | 156.66 us | 1.28 us | 4.87 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.75 us | 2.37 us | 3.36 us |
|