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 | 985 | 1635330599760 | 1660233960 | 45530987568 | |
root | wait/io/file/sql/binlog | 440 | 1152299453184 | 2618862312 | 95216539968 | |
root | wait/lock/metadata/sql/mdl | 3 | 1035166410960 | 345055470144 | 999426335952 | |
root | wait/io/file/innodb/innodb_temp_file | 38 | 392674568880 | 10333541064 | 38544778272 | |
root | wait/io/table/sql/handler | 45517 | 119067524400 | 2615712 | 6092711856 | |
root | wait/io/file/sql/io_cache | 178 | 76341954480 | 428887272 | 68091256992 | |
root | wait/io/file/sql/ERRMSG | 60 | 34874194608 | 581236392 | 4210302096 | |
root | wait/lock/table/sql/handler | 585 | 1340059248 | 2290464 | 669774864 | |
root | wait/io/file/sql/binlog_index | 2 | 1185037392 | 592518696 | 1182945456 | |
root | wait/io/file/sql/misc | 11 | 806747568 | 73340520 | 411104496 | |
root | wait/io/file/myisam/kfile | 4 | 364762992 | 91190616 | 234313728 | |
root | wait/io/file/myisam/dfile | 4 | 300921984 | 75230496 | 278555376 |
|