SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 874 | 2.94 s | 3.37 ms | 54.51 ms | |
root | wait/io/file/sql/binlog | 713 | 970.75 ms | 1.36 ms | 49.32 ms | |
root | wait/lock/metadata/sql/mdl | 5 | 560.97 ms | 112.19 ms | 262.00 ms | |
root | wait/io/file/innodb/innodb_temp_file | 20 | 223.61 ms | 11.18 ms | 31.16 ms | |
root | wait/io/table/sql/handler | 1665 | 58.04 ms | 34.86 us | 15.57 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 45.02 ms | 750.34 us | 3.43 ms | |
root | wait/io/file/sql/io_cache | 276 | 5.82 ms | 21.07 us | 600.92 us | |
root | wait/io/file/csv/metadata | 8 | 2.96 ms | 369.76 us | 1.57 ms | |
root | wait/io/file/myisam/kfile | 4 | 2.51 ms | 627.39 us | 2.43 ms | |
root | wait/lock/table/sql/handler | 1706 | 2.48 ms | 1.45 us | 11.91 us | |
root | wait/io/file/sql/misc | 3 | 2.11 ms | 702.73 us | 2.08 ms | |
root | wait/io/file/csv/data | 4 | 36.88 us | 9.22 us | 15.10 us | |
root | wait/io/file/myisam/dfile | 2 | 35.23 us | 17.61 us | 31.57 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.40 us | 2.20 us | 2.73 us |
|