SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 384 | 608387716992 | 1584342936 | 23585433696 | |
root | wait/lock/metadata/sql/mdl | 1 | 259423626000 | 259423626000 | 259423626000 | |
root | wait/io/file/innodb/innodb_data_file | 674 | 185537562144 | 275278080 | 32141788800 | |
root | wait/io/table/sql/handler | 412 | 92018818320 | 223346640 | 69268234992 | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 64497926064 | 10749654168 | 26062841904 | |
root | wait/io/file/sql/ERRMSG | 50 | 27167717808 | 543354240 | 2340627696 | |
root | wait/io/file/myisam/kfile | 9 | 2581404672 | 286822536 | 1561753776 | |
root | wait/io/file/myisam/dfile | 7 | 767789616 | 109684080 | 616408848 | |
root | wait/io/file/csv/metadata | 8 | 696275712 | 87034464 | 343093872 | |
root | wait/io/file/sql/misc | 8 | 324483456 | 40560432 | 199462032 | |
root | wait/lock/table/sql/handler | 215 | 210518880 | 978912 | 3411408 | |
root | wait/io/file/csv/data | 4 | 40909968 | 10227360 | 18208608 | |
root | wait/io/file/sql/binlog_index | 2 | 17183232 | 8591616 | 14007840 |
|