SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 74 | 684126266736 | 9244949472 | 36748192800 | |
root | wait/io/file/innodb/innodb_data_file | 345 | 409146534720 | 1185931824 | 29390284176 | |
root | wait/io/file/sql/binlog | 404 | 328734721920 | 813699744 | 32480427936 | |
root | wait/lock/metadata/sql/mdl | 4 | 69192041952 | 17298010488 | 28460205840 | |
root | wait/io/table/sql/handler | 1225 | 37349047824 | 30488832 | 9160803168 | |
root | wait/io/file/sql/ERRMSG | 45 | 28869892128 | 641553000 | 2315502816 | |
root | wait/io/file/sql/io_cache | 68 | 7116027600 | 104647224 | 5536123824 | |
root | wait/io/file/csv/metadata | 8 | 1361010288 | 170126088 | 563600928 | |
root | wait/lock/table/sql/handler | 664 | 884978688 | 1332672 | 4831728 | |
root | wait/io/file/csv/data | 4 | 263695872 | 65923968 | 198724944 | |
root | wait/io/file/sql/misc | 4 | 82600320 | 20650080 | 29212656 | |
root | wait/io/file/sql/binlog_index | 2 | 6383520 | 3191760 | 3963168 |
|