SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 424 | 836732569200 | 1973425608 | 27766424400 | |
root | wait/io/file/innodb/innodb_data_file | 846 | 773926864128 | 914806992 | 43248693312 | |
root | wait/io/file/innodb/innodb_temp_file | 42 | 356167338384 | 8480174472 | 26034060624 | |
root | wait/lock/metadata/sql/mdl | 1 | 309677198688 | 309677198688 | 309677198688 | |
root | wait/io/table/sql/handler | 89432 | 203546362800 | 2275944 | 13487183424 | |
root | wait/io/file/sql/ERRMSG | 50 | 24453500016 | 489069768 | 2282153280 | |
root | wait/io/file/csv/metadata | 4 | 15070001760 | 3767500440 | 11137947744 | |
root | wait/io/file/sql/misc | 11 | 1591125888 | 144647712 | 1429414272 | |
root | wait/io/file/sql/io_cache | 30 | 540561120 | 18018528 | 52316880 | |
root | wait/lock/table/sql/handler | 271 | 287211936 | 1059696 | 13351536 | |
root | wait/io/file/myisam/kfile | 4 | 258429600 | 64607400 | 180760272 | |
root | wait/io/file/myisam/dfile | 4 | 158462304 | 39615576 | 134402928 | |
root | wait/io/file/csv/data | 2 | 44731104 | 22365552 | 39568848 | |
root | wait/io/file/sql/binlog_index | 2 | 5470080 | 2735040 | 3414576 |
|