SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 46 | 454436275920 | 9879049224 | 38947734144 | |
root | wait/io/file/innodb/innodb_data_file | 228 | 65095845408 | 285508080 | 2748181920 | |
root | wait/io/file/sql/ERRMSG | 50 | 31696062816 | 633921024 | 2485668768 | |
root | wait/io/table/sql/handler | 155 | 7464408336 | 48157296 | 3177943824 | |
root | wait/io/file/sql/binlog | 156 | 823525296 | 5278944 | 28186752 | |
root | wait/io/file/csv/metadata | 4 | 663244560 | 165811008 | 528152592 | |
root | wait/io/file/csv/data | 2 | 307807104 | 153903552 | 298958880 | |
root | wait/lock/table/sql/handler | 94 | 81708000 | 869088 | 3353328 | |
root | wait/io/file/sql/binlog_index | 2 | 5375568 | 2687784 | 3444144 |
|