SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 102 | 939001700736 | 9205898856 | 32031523392 | |
root | wait/io/file/innodb/innodb_data_file | 267 | 242356555056 | 907702224 | 27477734064 | |
root | wait/io/file/sql/binlog | 442 | 139907852832 | 316533360 | 20775735552 | |
root | wait/io/file/sql/ERRMSG | 45 | 36465339504 | 810340872 | 3808826208 | |
root | wait/io/table/sql/handler | 1018 | 15352935840 | 15081264 | 1715550144 | |
root | wait/io/file/myisam/kfile | 12 | 2276082336 | 189673440 | 1021983072 | |
root | wait/io/file/sql/io_cache | 52 | 1695639792 | 32608224 | 134384976 | |
root | wait/io/file/myisam/dfile | 95 | 944479536 | 9941712 | 406712592 | |
root | wait/io/file/sql/misc | 4 | 852639744 | 213159936 | 598128432 | |
root | wait/lock/table/sql/handler | 631 | 811771488 | 1286472 | 7601616 | |
root | wait/io/file/sql/binlog_index | 2 | 4088304 | 2044152 | 2727120 |
|