SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
pma | wait/lock/metadata/sql/mdl | 4 | 76957625184 | 19239406296 | 35703159360 | |
root | wait/io/table/sql/handler | 513 | 1385629163952 | 2701031256 | 715886252400 | |
root | wait/lock/metadata/sql/mdl | 19 | 276406449264 | 14547707856 | 65778165024 | |
root | wait/io/file/sql/binlog | 32 | 125457130656 | 3920535168 | 41839874736 | |
root | wait/io/file/innodb/innodb_data_file | 176 | 66976436736 | 380547816 | 5609708544 | |
root | wait/io/file/sql/ERRMSG | 60 | 40378110960 | 672968472 | 12375832128 | |
root | wait/io/file/innodb/innodb_temp_file | 4 | 31463476176 | 7865868912 | 19656650640 | |
root | wait/io/file/csv/metadata | 4 | 397199088 | 99299640 | 336513408 | |
root | wait/io/file/csv/data | 2 | 221022384 | 110511192 | 214909728 | |
root | wait/lock/table/sql/handler | 104 | 96354720 | 926376 | 3867600 | |
root | wait/io/file/sql/misc | 1 | 10134432 | 10134432 | 10134432 | |
root | wait/io/file/sql/binlog_index | 2 | 5082528 | 2541264 | 3355440 |
|