A simple way to remove all the SPAM posts that fill up the of WordPress database..
The Plugin named “Optimize Database after Deleting Revisions” is excellent for removing all comments listed as SPAM that are taking up space in a database, and maybe slowing down a website.
The SPAM removal feature is an option in this plugin, and when activated removes all comments previously marked as spam by plugins such as Akismet. This can be set to run Hourly, Daily or Weekly.
Deletes redundant revisions of posts and pages (you optionally can keep an ‘x’-amount of the most recent revisions)
Deletes trashed posts, pages and comments (optional)
Deletes spammed comments (optional)
Deletes unused tags (optional)
Deletes ‘expired transients’ (optional)
Deletes ‘pingbacks’ and ‘trackbacks’ (optional)
Deletes ‘orphan postmeta items’
Optimizes the database tables (optionally you can exclude certain tables from optimization)
Creates a log file of the optimizations (optional)
Optimization can be scheduled to automatically run once hourly, twice daily, once daily or once weekly at a specific time (optional)
‘Optimize DB (1 click)’ link in the admin bar (optional)
‘Optimize Database’ Icon in the admin menu (optional)
WordPress Plugin Tips
24.1 - 739,637