SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 5301864 | 3911112161616 | 737616 | 6412158720 | |
root | wait/io/file/innodb/innodb_temp_file | 30 | 330671386320 | 11022379368 | 33377918640 | |
root | wait/io/file/innodb/innodb_data_file | 630 | 178399732368 | 283174056 | 6606431568 | |
root | wait/io/file/sql/ERRMSG | 60 | 51313191072 | 855219816 | 3117197424 | |
root | wait/io/file/sql/binlog | 300 | 11397403248 | 37991184 | 9787292064 | |
root | wait/io/file/myisam/kfile | 16 | 8353206048 | 522075312 | 3266322576 | |
root | wait/io/file/myisam/dfile | 36 | 2776150080 | 77115192 | 1961594448 | |
root | wait/lock/table/sql/handler | 1453 | 1668167952 | 1147872 | 198306240 | |
root | wait/io/file/sql/binlog_index | 2 | 7445328 | 3722664 | 5568816 |
|