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 | 58 | 652622801424 | 11252117184 | 107799641136 | |
root | wait/io/table/sql/handler | 984648 | 507289872144 | 515064 | 4020309216 | |
root | wait/io/file/innodb/innodb_data_file | 462 | 421679645904 | 912726408 | 29712722688 | |
root | wait/io/file/sql/binlog | 520 | 312807406560 | 601552512 | 33635087376 | |
root | wait/io/file/sql/ERRMSG | 55 | 52455577152 | 953737752 | 6083293392 | |
root | wait/io/file/myisam/dfile | 4388 | 6125657472 | 1395768 | 2287743216 | |
root | wait/io/file/myisam/kfile | 16 | 3241972800 | 202623168 | 1426145952 | |
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 | 752 | 851866752 | 1132560 | 4828032 | |
root | wait/io/file/sql/misc | 8 | 174419520 | 21802440 | 31740720 | |
root | wait/io/file/sql/binlog_index | 2 | 4423056 | 2211528 | 2802624 |
|