SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 928 | 1.44 s | 1.55 ms | 42.29 ms | |
root | wait/io/file/sql/binlog | 343 | 1.06 s | 3.09 ms | 32.52 ms | |
root | wait/io/table/sql/handler | 267160 | 423.42 ms | 1.58 us | 26.61 ms | |
root | wait/lock/metadata/sql/mdl | 2 | 360.23 ms | 180.12 ms | 226.63 ms | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 76.21 ms | 7.62 ms | 16.90 ms | |
root | wait/io/file/sql/io_cache | 344 | 41.28 ms | 120.00 us | 12.85 ms | |
root | wait/io/file/sql/ERRMSG | 35 | 28.01 ms | 800.28 us | 5.66 ms | |
root | wait/io/file/myisam/kfile | 9 | 16.38 ms | 1.82 ms | 15.79 ms | |
root | wait/io/file/csv/metadata | 8 | 3.71 ms | 463.57 us | 2.24 ms | |
root | wait/lock/table/sql/handler | 333 | 293.95 us | 882.55 ns | 3.73 us | |
root | wait/io/file/sql/misc | 3 | 265.12 us | 88.37 us | 224.05 us | |
root | wait/io/file/myisam/dfile | 7 | 45.55 us | 6.51 us | 12.28 us | |
root | wait/io/file/csv/data | 4 | 40.95 us | 10.24 us | 17.53 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.12 us | 2.06 us | 2.70 us |
|