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 | 28 | 260948978400 | 9319606296 | 23961607824 | |
root | wait/io/file/innodb/innodb_data_file | 202 | 58898271168 | 291575592 | 2748181920 | |
root | wait/io/file/sql/ERRMSG | 45 | 30413947344 | 675865344 | 2485668768 | |
root | wait/io/table/sql/handler | 155 | 7464408336 | 48157296 | 3177943824 | |
root | wait/io/file/csv/metadata | 4 | 663244560 | 165811008 | 528152592 | |
root | wait/io/file/sql/binlog | 108 | 566451600 | 5244888 | 26656080 | |
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 |
|