Excluding specific posts/pages from deleting revisions

If you want to keep revisions for a specific post/page (no matter what the other settings are), create a custom field named ‘keep_revisions’ for that post/page and give it the value ‘Y’

Starting the Optimization

You can start the Optimization in the WP Admin Panel » Optimize Database.
Note: if you use the Scheduler the Optimization will run automatically!
Note: you also can click the ‘Optimize DB (1 click)’ link in the admin bar (if enabled)

Multisite Support

Install the plugin as Network Administrator (Network Admin » Plugins)

‘Network Activate’ the plugin

You only can configure and run the plugin on the main network site, but it will optimize ALL the sub-sites too!

That’s because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.

Update: if you want to optimize your InnoDB tables too, just check the ‘Optimize InnoDB tables too’ option on the settings page

After I ran the plugin, I got “Total savings since the first run: -64 KB”

Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables).
Optimizing InnoDB tables works differently than MyISAM.
InnoDB focuses on speed optimization and sometimes it means the database can grow a little.

I scheduled the optimization for 8pm but it runs at 6pm (my local time)

The scheduler uses the local time of the web server which can differ from your own local time

The plugin is visible in Main Site Tools but not in my subsites

Multisite Support
– Install the plugin as Network Administrator (Network Admin » Plugins)
– ‘Network Activate’ the plugin
– You only can configure and run the plugin on the main network site, but it will optimize ALL the sub-sites too!