We are using Mysql as database on Amazon RDS, Php as language and Wordpress as the platform.
Our instance Cpu utilization is shooting to 100% when we click the most dynamic page of our website.
For the smooth running of sql queries , we need to index the database - to have a quick results on search.
And also want to optimize some queries to increase the page speed and performance of the system
We want to resolve all these issues,