Back in the old days I've written a very simple script to remove posts' revisions from WordPress database. It was published on my GitHub, but it was broken due to syntax error in SQL query... and it was a good thing because it might actually remove important content from your database.
And yet, the time has come. I sat down and rewrote whole script from scratch. Turned it into modular WordPress cleaner, improving performance of your installation by removing tons of garbage from your database. It is now able to remove following kinds of junk:
- post revisions (disabled by default)
- auto drafts
- spam comments
- unapproved comments
- orphan commentmeta
- orphan postmeta
- transient options
- akismet commentmeta
Look how the script performs on production database of my website (using default settings).
You can grab it from GitHub repository. Feedback and contributions are welcome!