So ...

This handy plugin is an effective tool for automatically cleaning your WordPress database so that it runs at maximum efficiency.

Here are the most important features:

• removes all unnecessary data (e.g. trashed/unapproved/spam comments, stale data) plus pingbacks, trackbacks and expired transient options
• compact/de-fragment MySQL tables with a button-press
• compress (“smush”) images (existing images and automatically on new ones)
• detailed control of which optimizations you wish to carry out
• carries out automatic weekly (or otherwise) clean-ups
• retains a set number of weeks’ data during clean-ups
• performs optimizations without the need for running manual queries
• automatically trigger a pre-optimize backup via UpdraftPlus
• show database statistics and potential savings
• mobile friendly and easy-to-use
• translated into several languages

The plugin will help you to ...

• make space: when you edit a post/page, Wordpress automatically saves the new revision to the database; now if you edit your content a few times, your database soon gets clogged up with old revisions that just sit there, taking up valuable space; the plugin will remove these unnecessary post revisions, freeing up valuable space and increasing speed and efficiency; it also cleans up your comments table, removing all the spam and un-approved comments that have built up
• take control: the plugin reports on exactly which of your database tables have overhead and wasted space, giving you the insight, control and power to keep your website neat, fast and efficient
• keep it clean: once enabled, the plugin can run an automatic clean-up on a schedule, keeping a selected number of weeks’ data, according to your specification
• optimize your images; the plugin comes with built-in image optimization features that will allow you to automatically compress newly-added images

Now let' see the magic ...