Database Indexing and query optimization needed

Database Indexing and query optimization needed

Cancelled

Job Description

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 through Team viewer,