SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 979616 | 600338041776 | 612744 | 66784184544 | |
root | wait/io/file/innodb/innodb_data_file | 276 | 161162763696 | 583922856 | 35124104400 | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 21241068288 | 10620534144 | 21195194592 | |
root | wait/io/file/sql/ERRMSG | 25 | 12610472688 | 504418728 | 2189803440 | |
root | wait/io/file/sql/binlog | 64 | 2213350656 | 34583472 | 1913970960 | |
root | wait/io/file/csv/metadata | 4 | 1630236432 | 407558976 | 1225922016 | |
root | wait/io/file/sql/io_cache | 30 | 1258378176 | 41945904 | 656307168 | |
root | wait/lock/table/sql/handler | 242 | 227319840 | 939312 | 6302208 | |
root | wait/io/file/csv/data | 2 | 42926400 | 21463200 | 30791376 | |
root | wait/io/file/sql/binlog_index | 2 | 12194688 | 6097344 | 10609104 |
|