Register and ask your own question!
Slow Create Temp Table/ CREATE INDEX on temp table
version | 5.7.26-29
version_comment | Percona Server (GPL), Release 29, Revision 11ad961
Sometimes creating empty temp tables or adding indexes on emprty temp tables can take seconds rather than milliseconds.
Looking at events_waits_current data when the objects are being created the waits are.
I also found the /mysql/data/ibtmp1 has the highest wait time in the file_summary_by_instance table. The server is an ec2 instance and we don't appear to getting near the provisioned iops for the MySQL drive.
Sometimes the objects are created fast other times they are really slow. Please can anyone suggest the underlying cause or how I can understand the problem better.