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 | 22 | 251393278224 | 11426967024 | 37880610240 | |
root | wait/io/file/sql/binlog | 122 | 79686918432 | 653171376 | 22488171552 | |
root | wait/io/file/innodb/innodb_data_file | 204 | 53337157104 | 261456624 | 3731390784 | |
root | wait/io/file/sql/ERRMSG | 40 | 32580583728 | 814514448 | 3923430720 | |
root | wait/io/table/sql/handler | 165 | 11411799168 | 69162192 | 2696408352 | |
root | wait/io/file/sql/io_cache | 30 | 1443843456 | 48127992 | 493423392 | |
root | wait/io/file/sql/misc | 4 | 109132848 | 27283080 | 70083024 | |
root | wait/lock/table/sql/handler | 47 | 50341632 | 1071048 | 4427808 | |
root | wait/io/file/sql/binlog_index | 2 | 4664880 | 2332440 | 2805792 |
|