SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 2449212 | 1.19 s | 485.23 ns | 4.52 ms | |
root | wait/io/file/sql/binlog | 124 | 331.18 ms | 2.67 ms | 30.68 ms | |
root | wait/io/file/innodb/innodb_data_file | 335 | 127.73 ms | 381.27 us | 26.50 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 45.30 ms | 823.63 us | 4.23 ms | |
root | wait/io/file/innodb/innodb_temp_file | 4 | 38.57 ms | 9.64 ms | 26.28 ms | |
root | wait/io/file/myisam/kfile | 109 | 3.58 ms | 32.85 us | 1.88 ms | |
root | wait/io/file/csv/metadata | 8 | 2.31 ms | 288.31 us | 1.70 ms | |
root | wait/io/file/myisam/dfile | 121 | 1.42 ms | 11.71 us | 755.87 us | |
root | wait/io/file/sql/SDI | 15 | 943.17 us | 62.88 us | 409.18 us | |
root | wait/io/file/sql/misc | 4 | 283.30 us | 70.82 us | 242.93 us | |
root | wait/lock/table/sql/handler | 209 | 257.69 us | 1.23 us | 13.66 us | |
root | wait/io/file/csv/data | 9 | 66.73 us | 7.41 us | 17.13 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.25 us | 2.62 us | 3.31 us |
|