SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 187 | 66.17 ms | 353.87 us | 12.05 ms | |
root | wait/io/file/innodb/innodb_temp_file | 8 | 64.47 ms | 8.06 ms | 22.37 ms | |
root | wait/io/file/sql/ERRMSG | 30 | 29.44 ms | 981.21 us | 7.39 ms | |
root | wait/io/file/sql/binlog | 46 | 16.93 ms | 368.15 us | 16.46 ms | |
root | wait/io/file/sql/io_cache | 54 | 2.78 ms | 51.45 us | 1.19 ms | |
root | wait/io/file/csv/metadata | 8 | 2.44 ms | 304.49 us | 1.16 ms | |
root | wait/io/table/sql/handler | 9 | 1.01 ms | 111.88 us | 663.57 us | |
root | wait/io/file/myisam/kfile | 8 | 929.38 us | 116.17 us | 750.61 us | |
root | wait/io/file/csv/data | 41 | 295.38 us | 7.20 us | 39.07 us | |
root | wait/io/file/myisam/dfile | 8 | 266.26 us | 33.28 us | 226.30 us | |
root | wait/io/file/sql/binlog_index | 2 | 175.12 us | 87.56 us | 173.26 us | |
root | wait/lock/table/sql/handler | 39 | 49.23 us | 1.26 us | 3.51 us |
|