SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 22 | 226.41 ms | 10.29 ms | 50.27 ms | |
root | wait/io/file/innodb/innodb_data_file | 359 | 165.27 ms | 460.37 us | 25.24 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 90.20 ms | 1.29 ms | 41.46 ms | |
root | wait/io/file/sql/binlog | 120 | 85.75 ms | 714.61 us | 17.50 ms | |
root | wait/io/table/sql/handler | 1466 | 42.01 ms | 28.65 us | 10.58 ms | |
root | wait/io/file/sql/io_cache | 38 | 2.51 ms | 66.11 us | 1.68 ms | |
root | wait/io/file/sql/misc | 1 | 1.89 ms | 1.89 ms | 1.89 ms | |
root | wait/io/file/csv/metadata | 8 | 1.23 ms | 153.99 us | 542.46 us | |
root | wait/io/file/csv/data | 8 | 1.08 ms | 134.57 us | 1.02 ms | |
root | wait/lock/table/sql/handler | 486 | 472.29 us | 971.78 ns | 14.16 us | |
root | wait/io/file/sql/binlog_index | 2 | 227.08 us | 113.54 us | 225.50 us |
|