SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 1656 | 756.34 ms | 456.73 us | 161.28 ms | |
root | wait/io/file/innodb/innodb_temp_file | 30 | 336.19 ms | 11.21 ms | 37.42 ms | |
root | wait/io/file/innodb/innodb_data_file | 558 | 183.24 ms | 328.38 us | 20.77 ms | |
root | wait/io/file/sql/ERRMSG | 65 | 32.81 ms | 504.83 us | 4.56 ms | |
root | wait/io/table/sql/handler | 260 | 17.83 ms | 68.59 us | 6.37 ms | |
root | wait/io/file/myisam/kfile | 4 | 14.52 ms | 3.63 ms | 14.11 ms | |
root | wait/io/file/sql/io_cache | 134 | 9.95 ms | 74.26 us | 5.71 ms | |
root | wait/io/file/csv/metadata | 4 | 1.74 ms | 434.64 us | 1.27 ms | |
root | wait/io/file/csv/data | 2 | 648.70 us | 324.35 us | 609.51 us | |
root | wait/io/file/myisam/dfile | 4 | 589.33 us | 147.33 us | 513.41 us | |
root | wait/lock/table/sql/handler | 340 | 449.14 us | 1.32 us | 16.87 us | |
root | wait/io/file/sql/misc | 6 | 92.18 us | 15.36 us | 27.16 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.15 us | 2.57 us | 3.29 us |
|