SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1157489 | 886075678752 | 765336 | 66784184544 | |
root | wait/io/file/innodb/innodb_temp_file | 72 | 815860366992 | 11331393744 | 210583685136 | |
root | wait/io/file/innodb/innodb_data_file | 664 | 297515560848 | 448065552 | 35124104400 | |
root | wait/io/file/sql/io_cache | 826 | 42838799520 | 51862800 | 15745989072 | |
root | wait/io/file/sql/ERRMSG | 65 | 37418048976 | 575662032 | 2189803440 | |
root | wait/io/file/sql/binlog | 352 | 6749947776 | 19175904 | 1913970960 | |
root | wait/io/file/csv/metadata | 8 | 2268563088 | 283570320 | 1225922016 | |
root | wait/io/file/myisam/kfile | 16 | 1995569136 | 124722840 | 601094736 | |
root | wait/lock/table/sql/handler | 719 | 754857312 | 1049664 | 15246528 | |
root | wait/io/file/csv/data | 8 | 414571872 | 51821352 | 340529376 | |
root | wait/io/file/myisam/dfile | 8 | 77397936 | 9674544 | 29321952 | |
root | wait/io/file/sql/binlog_index | 2 | 12194688 | 6097344 | 10609104 |
|