SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 176 | 391559115024 | 2224767600 | 18512099760 | |
root | wait/io/file/innodb/innodb_data_file | 499 | 268748440224 | 538573992 | 99849899952 | |
root | wait/io/file/sql/ERRMSG | 55 | 35846976528 | 651763200 | 3128966544 | |
root | wait/io/file/csv/metadata | 8 | 1249384752 | 156172896 | 550479600 | |
root | wait/io/file/myisam/dfile | 4 | 442233792 | 110558448 | 420920016 | |
root | wait/io/file/myisam/kfile | 4 | 253496496 | 63373992 | 159232656 | |
root | wait/lock/table/sql/handler | 42 | 97032144 | 2310264 | 30077520 | |
root | wait/io/file/csv/data | 4 | 67052832 | 16763208 | 35466288 | |
root | wait/io/file/sql/binlog_index | 2 | 4983264 | 2491632 | 3023856 |
|