Optimize Database and MYSQL and apps performance

Job ID: 34607283

Budget: $250 – $750 AUD

I am having high Memory consumption on my servers (dedicated 8GB) at cloudways.
2 apps are running on it (www.thegooddeal.shop and www.equilibriumx.com).
The hosting has determined that there are some PHP scripts (index.php) running in a loop consuming memory.
I have disabled Hummingbird and revive Old Post plugins to eliminate possible culprits but the memory consumption remains with little traffic on the sites at this moment.
Both websites are running on WordPress with large databases of products and pages.
The hosting provider indicated that PHP queries have to be optimized in MySQL.
Related categories: PHP Linux WordPress MySQL Web Hosting