SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 220 | 59885944800 | 272208816 | 6725156064 | |
root | wait/io/table/sql/handler | 398 | 18947407776 | 47606328 | 7520848896 | |
root | wait/io/file/sql/ERRMSG | 35 | 13239268944 | 378264744 | 1635833760 | |
root | wait/io/file/myisam/kfile | 4 | 439841952 | 109960488 | 414368592 | |
root | wait/io/file/sql/binlog | 32 | 187076736 | 5846016 | 25304928 | |
root | wait/io/file/sql/binlog_index | 2 | 184269888 | 92134944 | 182501616 | |
root | wait/lock/table/sql/handler | 73 | 89562528 | 1226808 | 2502720 | |
root | wait/io/file/myisam/dfile | 2 | 9273264 | 4636632 | 8761632 |
|