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 | 24 | 202960251120 | 8456676888 | 26034060624 | |
root | wait/io/table/sql/handler | 88890 | 178201182192 | 2004552 | 1573952160 | |
root | wait/io/file/innodb/innodb_data_file | 341 | 86507516832 | 253687632 | 3148564320 | |
root | wait/io/file/sql/binlog | 180 | 51269984304 | 284833032 | 14622028080 | |
root | wait/io/file/sql/ERRMSG | 40 | 20197542816 | 504938544 | 2282153280 | |
root | wait/io/file/csv/metadata | 4 | 15070001760 | 3767500440 | 11137947744 | |
root | wait/io/file/sql/io_cache | 30 | 540561120 | 18018528 | 52316880 | |
root | wait/lock/table/sql/handler | 105 | 109168224 | 1039632 | 7423152 | |
root | wait/io/file/sql/misc | 4 | 49024800 | 12256200 | 14323584 | |
root | wait/io/file/csv/data | 2 | 44731104 | 22365552 | 39568848 | |
root | wait/io/file/sql/binlog_index | 2 | 5470080 | 2735040 | 3414576 |
|