I have written about how to reduced server load on a shared hosting here and here. It seems I missed one of the vital ways to reduce WordPress server load on shared hosting. I will talk in brief about one of the best ways to reduce server load. Most of wordpress users are aware that it works using a database which keeps on growing with the number of posts, comments and even plugins. This growth normally is not very systematic and often lead to errors in wordpress database. In technical language, we call it ” Overhead“
Just navigate to your Phpmyadmin in your webhost control panel like Cpanel or some other one and browse to your wordpress database. You will see a “overhead” column in your wordpress database structure. Ideally, there should be no values in that overhead column. Values in that column means your wordpress database is not optimised and in turn will take much more memory than it should. Now you need to clean it up. Dont worry its so simple.
Just move to bottom of the table, where you will find a option to select all the rows having overhewad values in just one click. After you selected that, just click on the dropdown box beside it and select optimise. Thats it. You are done and your wordpress database is optimised now.
You need to do this regularly if you want your WordPress blog to run smoothly. IF you do this often, say every 2-3 days you wont run into a high server load trouble on your shared hosting for long long time. Hopefully it helps everyone who got into this problem.
