After using WordPress for some months you may experience slowdown of your WordPress website. This is because of the junk present in your WordPress database. To clean the junk and optimize my database in a single click I use a plugin called WP-Optimize. Let’s see some of the causes and see how to Optimize the database.
Causes for Slowdown:
Every time when you edit a post a revison is stored. If you have thousands of posts more than 200 mb of database space is wasted. This causes Slowdown.
If you have many Spam comments in your queue it causes Slowdown. You can remove the Spam comments manually. You can automatically block spam comments by using a plugin called Akismet.
Even if you remove plugin from WordPress some plugins leave data in the Database. This wastes space in the database.
Optimizing WordPress Database:
->Download and install the plugin WP-Optimize.
->Open WP-Optimize from the left pane. It shows a clear data of your database tables and shows whether it is optimized or not.
-> Select the items that are to be removed from the database such as post revisions, auto draft posts, spam comments, trackbacks, pingbacks etc. Select Process to Optimize your WordPress website.
Scheduling Clean up:
This plugin has a cool feature which helps you to automatically clean up your database periodically such as weeks , months etc.
If you like this post share it.