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 | 50 | 586442442960 | 11728848648 | 107799641136 | |
root | wait/io/file/innodb/innodb_data_file | 247 | 267470048208 | 1082874672 | 29712722688 | |
root | wait/io/file/sql/binlog | 308 | 236251797936 | 767051208 | 25995204048 | |
root | wait/io/file/sql/ERRMSG | 50 | 44594853072 | 891896808 | 6083293392 | |
root | wait/io/table/sql/handler | 472 | 13793476224 | 29223216 | 4020309216 | |
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 | 239 | 266571360 | 1115136 | 4482192 | |
root | wait/io/file/sql/misc | 7 | 162299280 | 23185536 | 31740720 | |
root | wait/io/file/sql/binlog_index | 2 | 4423056 | 2211528 | 2802624 |
|