Performance optimization and Mysql load fixing of wordpress site

The following few steps will improve the performance and mysql load issues in wordpress.

First of take a full backup of the site so that you can revert back in case needed.

Then follow the steps:

Optimize Database:
a) Login to sites cpanel and then to phpmyadmin

b) Select the database and for each tables in it select "Operations" -> "Optimize table"


Install w3 total cache Plugin:
a) Login to wp-admin and install w3 total cache plugin

b) In its setting enable database cache.


These two simple steps had a huge impact of a wordpress site with 200000 posts in it.