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:
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.