SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 384 | 324925403616 | 846159864 | 165580142640 | |
root | wait/io/table/sql/handler | 490150 | 278314440624 | 567600 | 4609810656 | |
root | wait/io/file/innodb/innodb_temp_file | 4 | 40205799216 | 10051449672 | 22374149424 | |
root | wait/io/file/sql/ERRMSG | 35 | 24468846864 | 699109752 | 5326272864 | |
root | wait/io/file/sql/binlog | 30 | 13389441648 | 446314704 | 12732776496 | |
root | wait/io/file/myisam/kfile | 4 | 559573344 | 139893336 | 534737808 | |
root | wait/io/file/sql/misc | 1 | 204941088 | 204941088 | 204941088 | |
root | wait/io/file/sql/binlog_index | 2 | 177771264 | 88885632 | 175215216 | |
root | wait/lock/table/sql/handler | 142 | 140056224 | 986304 | 2838528 | |
root | wait/io/file/myisam/dfile | 2 | 10201488 | 5100744 | 9499776 |
|