I was researching this online and I found this blog post might be related to your case: https://forums.percona.com/t/created-tmp-files-what-is-the-cause/1231
Looks like the increase in the Created_tmp_files resides in the memory and could be caused due to unindexed group by/order by.
Created_tmp_files: How many temporary files mysqld has created.
Most likely related to some queries. Might need your DBAs to take a deeper look.
--> Regarding to the performance, general troubleshooting need to make sure:
- Instance having enough resources (CPU, Memory, Throughput, these can be reviewed in CloudWatch, Performance Insight)
- If certain query having performance issue, then need to investigate the query plan, and tune the query.
- If you suspect something from AWS end causing the performance issue, you may open a support case with us for us to look into storage and host.
MySQL RDS Performance issue(RDS instance restart)asked 7 months ago
Why the LoginFailures metric showing no data for RDS MySQL instance?asked 4 years ago
Created_tmp_files value always showing huge- MySQL RDS performance issueasked 6 months ago
[Announcement] Extending end-of-life process for Amazon RDS for MySQL 5.6asked a year ago
Can I import an RDS uncrypted mysql snapshot to an RDS encrypted mysql?Accepted Answerasked 6 months ago
[Announcement] Extending end-of-life process for Amazon RDS for MySQL 5.5asked 2 years ago
RDS MYSQL 8.0 parameter group value is not updatingasked 9 months ago
Error when modifying db.m5.xlarge RDS MySQL for Performance Insightsasked 3 years ago
Does enabling performance insights for mysql rds require restart?Accepted Answerasked a month ago
Migrate RDS MySQL 8.0.28 to Aurora MySQLasked a month ago