SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 72 | 762.86 ms | 10.60 ms | 69.94 ms | |
root | wait/io/file/innodb/innodb_data_file | 367 | 121.18 ms | 330.19 us | 14.68 ms | |
root | wait/io/file/sql/io_cache | 274 | 77.85 ms | 284.13 us | 48.33 ms | |
root | wait/io/table/sql/handler | 454 | 70.72 ms | 155.78 us | 37.43 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 34.78 ms | 695.52 us | 2.91 ms | |
root | wait/io/file/sql/binlog | 244 | 3.85 ms | 15.79 us | 1.74 ms | |
root | wait/io/file/myisam/kfile | 8 | 603.80 us | 75.47 us | 288.75 us | |
root | wait/lock/table/sql/handler | 424 | 581.34 us | 1.37 us | 5.86 us | |
root | wait/io/file/myisam/dfile | 13 | 571.67 us | 43.97 us | 263.66 us | |
root | wait/io/file/sql/binlog_index | 2 | 232.99 us | 116.50 us | 231.64 us |
|