SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 262 | 59997265152 | 228997032 | 4214348160 | |
root | wait/io/file/sql/ERRMSG | 40 | 41743054848 | 1043576160 | 6159199200 | |
root | wait/io/table/sql/handler | 554 | 9563898960 | 17263224 | 2821687968 | |
root | wait/io/file/sql/io_cache | 30 | 988664688 | 32955384 | 491571168 | |
root | wait/io/file/csv/metadata | 4 | 379895472 | 94973736 | 323330304 | |
root | wait/io/file/sql/binlog | 48 | 266131536 | 5544264 | 26406864 | |
root | wait/lock/table/sql/handler | 123 | 106256304 | 863808 | 3489552 | |
root | wait/io/file/csv/data | 2 | 14508384 | 7254192 | 9555216 | |
root | wait/io/file/sql/binlog_index | 2 | 4185456 | 2092728 | 2439360 |
|