SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 102 | 956.68 ms | 9.38 ms | 39.58 ms | |
root | wait/io/file/sql/binlog | 622 | 709.20 ms | 1.14 ms | 24.36 ms | |
root | wait/io/file/innodb/innodb_data_file | 674 | 418.76 ms | 621.31 us | 28.69 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 65.03 ms | 1.30 ms | 14.31 ms | |
root | wait/io/table/sql/handler | 4290 | 46.96 ms | 10.95 us | 11.24 ms | |
root | wait/io/file/sql/io_cache | 164 | 35.19 ms | 214.56 us | 23.59 ms | |
root | wait/io/file/csv/metadata | 8 | 1.41 ms | 176.13 us | 811.01 us | |
root | wait/lock/table/sql/handler | 1005 | 1.28 ms | 1.27 us | 14.38 us | |
root | wait/io/file/myisam/kfile | 4 | 1.18 ms | 294.46 us | 1.08 ms | |
root | wait/io/file/sql/binlog_index | 2 | 203.71 us | 101.85 us | 201.33 us | |
root | wait/io/file/csv/data | 4 | 53.15 us | 13.29 us | 28.65 us | |
root | wait/io/file/sql/misc | 4 | 52.33 us | 13.08 us | 23.50 us | |
root | wait/io/file/myisam/dfile | 4 | 51.15 us | 12.79 us | 25.29 us |
|