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 | 52 | 465934793808 | 8960284344 | 42151847232 | |
root | wait/io/file/innodb/innodb_data_file | 334 | 178894390752 | 535611912 | 46736263728 | |
root | wait/io/file/sql/binlog | 340 | 165679016976 | 487291200 | 123608327040 | |
root | wait/io/file/sql/ERRMSG | 55 | 31728096048 | 576874320 | 4883879616 | |
root | wait/io/table/sql/handler | 482 | 24292862352 | 50399976 | 4667752848 | |
root | wait/lock/table/sql/handler | 565 | 702270096 | 1242912 | 4118928 | |
root | wait/io/file/sql/misc | 2 | 145085424 | 72542712 | 132475728 | |
root | wait/io/file/sql/binlog_index | 2 | 4867632 | 2433816 | 3316896 |
|