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 | 44 | 513210530448 | 11663875608 | 107799641136 | |
root | wait/io/file/innodb/innodb_data_file | 180 | 206893173696 | 1149406368 | 29712722688 | |
root | wait/io/file/sql/binlog | 172 | 161132539920 | 936816936 | 25995204048 | |
root | wait/io/file/sql/ERRMSG | 45 | 42238198464 | 938626392 | 6083293392 | |
root | wait/io/table/sql/handler | 61 | 5245878528 | 85998000 | 862558752 | |
root | wait/io/file/csv/metadata | 4 | 2195997408 | 548999352 | 2100126336 | |
root | wait/io/file/csv/data | 8 | 1585688016 | 198210936 | 1553750352 | |
root | wait/lock/table/sql/handler | 80 | 95114976 | 1188792 | 3773088 | |
root | wait/io/file/sql/misc | 4 | 81416016 | 20353872 | 30627696 | |
root | wait/io/file/sql/binlog_index | 2 | 4423056 | 2211528 | 2802624 |
|