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 | 136 | 1287440247456 | 9466472400 | 39909061632 | |
root | wait/io/file/sql/binlog | 1143 | 839772016512 | 734708568 | 25269153888 | |
root | wait/io/file/innodb/innodb_data_file | 813 | 427898512272 | 526320432 | 31676238000 | |
root | wait/lock/metadata/sql/mdl | 1 | 178340041440 | 178340041440 | 178340041440 | |
root | wait/io/table/sql/handler | 13095 | 96562989072 | 7373784 | 35424728592 | |
root | wait/io/file/sql/ERRMSG | 75 | 49771803312 | 663623928 | 5279518992 | |
root | wait/io/file/sql/io_cache | 242 | 40651922256 | 167982936 | 15616464336 | |
root | wait/io/file/sql/binlog_index | 2 | 1318711152 | 659355576 | 1317740160 | |
root | wait/io/file/csv/metadata | 8 | 1156207008 | 144525744 | 458519952 | |
root | wait/io/file/myisam/kfile | 9 | 975238704 | 108359856 | 539112816 | |
root | wait/lock/table/sql/handler | 762 | 933809184 | 1225224 | 41084736 | |
root | wait/io/file/sql/misc | 17 | 556990368 | 32763984 | 317246688 | |
root | wait/io/file/csv/data | 26 | 386268960 | 14856336 | 173596368 | |
root | wait/io/file/myisam/dfile | 7 | 60240576 | 8605608 | 19443600 |
|