ATTENTION before testing any of these plugins on your site, make a database backup, better test on a separate test site!

There are many ways to clean the melon base; you can clean it manually, as well as automatic. As always and in everything, manual work is of better quality., but takes much longer. Today, we'll talk about a few plugins, that will help you clean up your database in WordPress and at the same time prevent it from growing from garbage further.

Your little top of the three plugins I split according to support criteria, simplicity and functionality.

3 place. Plugin for deleting revisions Better Delete Revision

Just a great plugin for cleaning revisions. Who does not know what revisions are, I'll try to explain in a nutshell. Every time you save an article, with any changes, WordPress keeps all copies of it in the database. These copies of the article “Revisions” can always be returned and everything seems to be perfectly invented.

While you do not have many articles, site is working fine, as soon as there are more articles, queries to the database are slower and the site starts to slow down. So that the database does not increase from unnecessary revisions, it is advisable to delete them.

Attention at the time of this writing, the plugin is already outdated, but still works well, I added it as an example, then I will talk about more interesting and complex tools.

Link to plugin

2 place. DB cleanup plugin : Clean Up Optimizer – Optimize & Clean Database

The plugin can clean up the database, manage user roles, add and remove rights for users, displays system information about the server, wordpress, php, mysql. Can display all versions of plugins and their licenses, shows information about the current topic. Very nice function to display CRON daemon tasks. Sometimes it is precisely because of the incorrect operation of CRON that the load increases significantly.

Of the minuses of the plugin, this is a crooked translation, but in general everything can be understood. I have personally used this plugin a little., there are various legends about him on the net, they write that it can spoil the base, others write that it is indispensable. I think everything is individual, Like any tool, you also need to know how to use it.. The PRO version gives really cool features, I advise you to look at it on your test site.

Link to plugin.

If you are a beginner, you do not want to figure out which of the functions you need, which is better not to touch, then I would suggest you a plugin WP-Optimize.

1 place. WP-Optimize Plugin. Easy WordPress Database Optimization

Very popular all over the internet, while I myself have not seen anything simpler with the same good functionality. Even the regular version is enough to clean.

For those, who likes to set up the site in automatic mode, you can purchase the PRO version and set up regular cleaning.

You can download the plugin here.

Limiting the number of revisions by the plugin

If you do not want to constantly clean up a bunch of revisions, which WordPress CMS creates automatically, you can use the plugin Revision Control, to limit their number or ban them entirely.

Limiting the number of revisions without a plugin

Ограничить количество ревизий или отключить их полностью можно также без плагина используя только файл настроек wp-config.php. Just add one of the constants below:

define( ‘WP_POST_REVISIONS’, 5 ); // limit the number of revisions to five.

define( ‘WP_POST_REVISIONS’, 0 ); // disable the creation of revisions completely.

You can read about how to clear the database of unnecessary options and the theme of unnecessary garbage in this article “Premium wordpress theme optimization, admin stopped slowing down“.

Good luck to everyone in speeding up your sites. If you don't understand write, I will work for you.