SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 251 | 1.31 s | 5.22 ms | 922.96 ms | |
root | wait/lock/metadata/sql/mdl | 1 | 336.05 ms | 336.05 ms | 336.05 ms | |
root | wait/io/file/sql/binlog | 96 | 192.31 ms | 2.00 ms | 21.01 ms | |
root | wait/io/file/innodb/innodb_temp_file | 16 | 149.89 ms | 9.37 ms | 35.10 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 107.13 ms | 2.68 ms | 72.66 ms | |
root | wait/io/table/sql/handler | 4027 | 12.64 ms | 3.14 us | 2.21 ms | |
root | wait/io/file/myisam/dfile | 3945 | 6.06 ms | 1.54 us | 2.20 ms | |
root | wait/io/file/sql/io_cache | 108 | 5.54 ms | 51.34 us | 2.09 ms | |
root | wait/io/file/myisam/kfile | 12 | 2.07 ms | 172.83 us | 1.44 ms | |
root | wait/io/file/sql/binlog_index | 2 | 153.68 us | 76.84 us | 151.80 us | |
root | wait/io/file/sql/misc | 7 | 143.84 us | 20.55 us | 48.03 us | |
root | wait/lock/table/sql/handler | 100 | 109.74 us | 1.10 us | 3.71 us |
|