Strapi crashes the RDS mysql instance after just two-three clicks

System Information
  • Strapi Version: 4.24.5
  • Operating System:
  • Database: mysql 8
  • Node Version: 20
  • NPM Version:
  • Yarn Version:

Hey fellow strapi enthusiasts,

I’m new with Strapi, I just deployed my first project, an apps catalog, similar to Softonic.com. Someone helped me with setting up the infrastructure on aws beanstalk. I’m running mysql 8 on a RDS instance, I’m running my strapi on an aws beanstalk env (couldn’t figure out the scaling part) and my next js frontend on a separate beanstalk env. Once I start doing a bit of testing by clicking around the website the DB crashes due to RDS CPU being at 100% and I start getting 504 errors and the website chrashes for a few minutes. This repeats every time I start testing.

Did anyone else have a similar issue? My catalog has over 800k apps, relations for categories, subcategories, license type, tags, media files stored on a S3 bucket.

Thanks in advance,
Andrei