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 | 142 | 44415882720 | 312787728 | 2074221072 | |
root | wait/io/file/sql/binlog | 38 | 13130830416 | 345548016 | 12749109648 | |
root | wait/io/table/sql/handler | 678 | 9530652384 | 14056944 | 1648048512 | |
root | wait/io/file/sql/ERRMSG | 20 | 9141062304 | 457052904 | 1831322592 | |
root | wait/lock/table/sql/handler | 91 | 99680064 | 1095336 | 3720816 | |
root | wait/io/file/sql/misc | 1 | 9748464 | 9748464 | 9748464 | |
root | wait/io/file/sql/binlog_index | 2 | 4903008 | 2451504 | 2868624 |
|