• Upload the Plugin to the /wp-content/plugins/ directory
• Activate the plugin in WP Admin Panel » Plugins

Starting the Analysis / 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)

You can click one of the following buttons:
‘Analyze (summary): analyzes the database and gives the count of what will be cleaned
‘Analyze (detail): analyzes the database and gives a detailed report of what will be deleted
‘Optimize (summary): actually deletes the items and gives the count of what has been deleted
‘Optimize (detail): actually deletes the items and gives a detailed report of what has been deleted

Settings

You can find the settings page in the WP Admin Panel » Settings » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings)

Delete revisions for the following (custom) post type(s):
– post
– page
[…]
Advise: just check them all.

Delete revisions older than XXX day(s)
Only revisions made more than XXX day(s) will be deleted.

Maximum number of – most recent – revisions to keep per post / page
Specify how many revisions you want to keep per post / page.
Fill ‘0’ in if you want to get rid of ALL revisions.

Delete trashed items
Delete all items that have been moved to the trash can by the editor(s) of the site.

Delete spammed items
Delete all items that have been marked as ‘spam’ by one of the editor (s) or by a plugin
(for instance Akismet)

Delete unused tags
Delete tags that are in the tags list but are not used in the site.

Delete (expired) transients
Transients are temporary ‘cookies’, stored in the database.
You can choose to:
– delete NO transients at all
– delete ALL transients
– delete ‘EXPIRED’ transients only
‘Expired transients’ are old transients that are fairly useless.

Delete pingbacks and trackbacks
See:
https://make.wordpress.org/support/user-manual/building-your-wordpress-community/trackbacks-and-pingbacks/

Clear oEmbed cache
oEmbeds are media filles that are cached in the database.
It makes media files to load faster on the site.
Often it are leftovers of media files that have been removed.
Therefore it’s useful to clear them every now and then.

Clear orphans
Orphans are records in the POSTMETA table that are pointing at a non-existing post record in the POSTS table.

Optimize InnoDB tables too
If your database is using InnoDB tables instead of MyISAM tables, you can choose if they should be optimized or not.

Keep a log
Keep a log of the optimization or not. The log will be stored in the database.

Scheduler
Run the optimization automatically or not
The options are HOURLY, TWICE A DAY, DAILY, WEEKLY or MONTHLY.

Show ‘1-click’ link in Admin Bar
Show a button in the Admin Bar (top of the WP Dashboard)

Show an icon in the Admin Menu
Show an icon in the Admin Menu (left column of the WP Dashboard)

Multisite Support

• Install the plugin as Network Administrator (Network Admin » Plugins)
• ‘Network Activate’ the plugin
• The settings are the same for ALL sites in the network, so if you change a setting for one site, it will be used for all other sites.
• If you run the plugin from any of the sites, it will cleanup ALL the sites in the network!