SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 3429710 | 1.71 s | 498.70 ns | 12.55 ms | |
root | wait/io/file/innodb/innodb_temp_file | 72 | 654.14 ms | 9.09 ms | 28.44 ms | |
root | wait/io/file/innodb/innodb_data_file | 475 | 165.53 ms | 348.48 us | 6.11 ms | |
root | wait/io/file/sql/io_cache | 452 | 73.72 ms | 163.09 us | 48.85 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 39.52 ms | 790.40 us | 3.59 ms | |
root | wait/io/file/csv/data | 78 | 31.10 ms | 398.73 us | 30.55 ms | |
root | wait/io/file/myisam/kfile | 16 | 3.68 ms | 229.76 us | 1.82 ms | |
root | wait/io/file/sql/binlog | 224 | 1.79 ms | 7.99 us | 384.97 us | |
root | wait/io/file/csv/metadata | 8 | 1.74 ms | 217.30 us | 792.78 us | |
root | wait/lock/table/sql/handler | 1205 | 1.52 ms | 1.26 us | 30.81 us | |
root | wait/io/file/myisam/dfile | 27 | 812.03 us | 30.08 us | 632.15 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.34 us | 2.67 us | 3.24 us |
|