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 | 52 | 606798380496 | 11669199432 | 107799641136 | |
root | wait/io/table/sql/handler | 979980 | 499148134320 | 509256 | 4020309216 | |
root | wait/io/file/innodb/innodb_data_file | 435 | 367490277792 | 844805016 | 29712722688 | |
root | wait/io/file/sql/binlog | 386 | 270725414256 | 701361144 | 33635087376 | |
root | wait/io/file/sql/ERRMSG | 55 | 52455577152 | 953737752 | 6083293392 | |
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 | 422 | 473067936 | 1120944 | 4828032 | |
root | wait/io/file/myisam/dfile | 35 | 333143712 | 9518256 | 281283024 | |
root | wait/io/file/sql/misc | 7 | 162299280 | 23185536 | 31740720 | |
root | wait/io/file/sql/binlog_index | 2 | 4423056 | 2211528 | 2802624 |
|