SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1157339 | 883694654304 | 763488 | 66784184544 | |
root | wait/io/file/innodb/innodb_temp_file | 60 | 713947717296 | 11899128384 | 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 | 300 | 6483310416 | 21610776 | 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 | 663 | 693176880 | 1045440 | 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 |
|