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 | 1678 | 6077582137968 | 3621920016 | 45530987568 | |
root | wait/io/file/sql/binlog | 1145 | 2802999420144 | 2448034248 | 95216539968 | |
root | wait/lock/metadata/sql/mdl | 16 | 1309466445408 | 81841652640 | 999426335952 | |
root | wait/io/file/innodb/innodb_temp_file | 94 | 1036350493728 | 11025005112 | 136008184752 | |
root | wait/io/table/sql/handler | 45591 | 120253411344 | 2637624 | 6092711856 | |
root | wait/io/file/sql/io_cache | 214 | 77288037552 | 361158864 | 68091256992 | |
root | wait/io/file/sql/ERRMSG | 80 | 51713037552 | 646412712 | 4210302096 | |
root | wait/lock/table/sql/handler | 1050 | 1979623008 | 1885224 | 669774864 | |
root | wait/io/file/sql/binlog_index | 2 | 1185037392 | 592518696 | 1182945456 | |
root | wait/io/file/sql/misc | 19 | 899909472 | 47363448 | 411104496 | |
root | wait/io/file/myisam/kfile | 4 | 364762992 | 91190616 | 234313728 | |
root | wait/io/file/myisam/dfile | 4 | 300921984 | 75230496 | 278555376 |
|