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 | 79 | 35435967072 | 448556328 | 2432351328 | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 18199688496 | 9099844248 | 18169154784 | |
root | wait/io/file/sql/ERRMSG | 20 | 15152587296 | 757629312 | 3286428288 | |
root | wait/io/table/sql/handler | 203 | 4180734624 | 20594640 | 1832987376 | |
root | wait/io/file/sql/io_cache | 44 | 1899768288 | 43176408 | 210424896 | |
root | wait/io/file/sql/binlog | 48 | 332310528 | 6923136 | 33863808 | |
root | wait/lock/table/sql/handler | 10 | 29544768 | 2954424 | 3734544 | |
root | wait/io/file/sql/binlog_index | 2 | 12184656 | 6092328 | 7800672 |
|