SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 16 | 187.83 ms | 11.74 ms | 35.02 ms | |
root | wait/io/file/innodb/innodb_data_file | 287 | 159.22 ms | 554.76 us | 32.12 ms | |
root | wait/io/file/sql/binlog | 89 | 94.07 ms | 1.06 ms | 15.78 ms | |
root | wait/io/file/sql/ERRMSG | 15 | 12.35 ms | 823.35 us | 3.80 ms | |
root | wait/io/table/sql/handler | 1002 | 12.03 ms | 12.01 us | 1.40 ms | |
root | wait/io/file/sql/io_cache | 258 | 8.83 ms | 34.23 us | 709.93 us | |
root | wait/io/file/csv/metadata | 8 | 1.45 ms | 181.39 us | 931.85 us | |
root | wait/io/file/sql/misc | 3 | 695.16 us | 231.72 us | 475.19 us | |
root | wait/io/file/csv/data | 9 | 352.20 us | 39.13 us | 301.10 us | |
root | wait/lock/table/sql/handler | 135 | 146.32 us | 1.08 us | 2.24 us | |
root | wait/lock/metadata/sql/mdl | 2 | 16.25 us | 8.13 us | 8.25 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.05 us | 2.53 us | 3.28 us |
|