SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 199 | 187.94 ms | 944.44 us | 109.08 ms | |
root | wait/io/file/innodb/innodb_temp_file | 8 | 72.86 ms | 9.11 ms | 23.32 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 27.72 ms | 615.94 us | 6.36 ms | |
root | wait/io/table/sql/handler | 56 | 10.73 ms | 191.54 us | 7.79 ms | |
root | wait/io/file/sql/io_cache | 185 | 5.25 ms | 28.36 us | 483.59 us | |
root | wait/io/file/sql/binlog | 8 | 2.41 ms | 300.76 us | 1.90 ms | |
root | wait/io/file/csv/metadata | 4 | 413.81 us | 103.45 us | 341.30 us | |
root | wait/io/file/sql/binlog_index | 2 | 189.47 us | 94.73 us | 187.59 us | |
root | wait/lock/table/sql/handler | 38 | 51.08 us | 1.34 us | 2.29 us | |
root | wait/io/file/csv/data | 2 | 16.42 us | 8.21 us | 10.65 us |
|