SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 983 | 3.16 s | 3.22 ms | 51.87 ms | |
root | wait/io/file/sql/binlog | 564 | 1.27 s | 2.25 ms | 30.40 ms | |
root | wait/io/file/innodb/innodb_temp_file | 68 | 638.37 ms | 9.39 ms | 40.29 ms | |
root | wait/io/file/sql/io_cache | 1617 | 252.73 ms | 156.29 us | 43.94 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 67.35 ms | 962.12 us | 5.94 ms | |
root | wait/io/table/sql/handler | 19026 | 37.53 ms | 1.97 us | 14.14 ms | |
root | wait/io/file/csv/metadata | 4 | 11.45 ms | 2.86 ms | 9.10 ms | |
root | wait/lock/table/sql/handler | 2145 | 2.10 ms | 977.59 ns | 15.47 us | |
root | wait/io/file/sql/misc | 6 | 2.09 ms | 347.99 us | 1.85 ms | |
root | wait/io/file/myisam/kfile | 4 | 587.17 us | 146.79 us | 528.92 us | |
root | wait/io/file/csv/data | 14 | 329.00 us | 23.50 us | 246.72 us | |
root | wait/io/file/myisam/dfile | 2 | 32.39 us | 16.20 us | 25.63 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.99 us | 2.49 us | 2.90 us |
|