SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 979717 | 496975485600 | 507144 | 4853746128 | |
root | wait/io/file/innodb/innodb_temp_file | 8 | 81064783536 | 10133097744 | 31079802336 | |
root | wait/io/file/innodb/innodb_data_file | 213 | 69188404560 | 324827976 | 3365868528 | |
root | wait/io/file/sql/ERRMSG | 40 | 28238435808 | 705960816 | 3771919008 | |
root | wait/io/file/sql/binlog | 86 | 16276666032 | 189263448 | 13015828320 | |
root | wait/io/file/sql/io_cache | 56 | 1561558944 | 27884736 | 552694032 | |
root | wait/io/file/csv/metadata | 4 | 396801504 | 99200376 | 345324144 | |
root | wait/io/file/csv/data | 2 | 209211024 | 104605512 | 201041808 | |
root | wait/lock/table/sql/handler | 209 | 171343392 | 819720 | 3949440 | |
root | wait/io/file/sql/misc | 1 | 9708864 | 9708864 | 9708864 | |
root | wait/io/file/sql/binlog_index | 2 | 4830144 | 2415072 | 2568720 |
|