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 | 320 | 171629813520 | 536342928 | 46736263728 | |
root | wait/io/file/sql/binlog | 332 | 165642600288 | 498923304 | 123608327040 | |
root | wait/io/file/sql/ERRMSG | 55 | 31728096048 | 576874320 | 4883879616 | |
root | wait/io/table/sql/handler | 377 | 19882766640 | 52739280 | 4667752848 | |
root | wait/lock/table/sql/handler | 470 | 570412128 | 1213608 | 4118928 | |
root | wait/io/file/sql/misc | 2 | 145085424 | 72542712 | 132475728 | |
root | wait/io/file/sql/binlog_index | 2 | 4867632 | 2433816 | 3316896 |
|