I ran this to delete the large number of post revisions on the site going back to 2009.
It ran in about 45 seconds and deleted 7,975 draft revisions and saved 100.807MB.
I prefer the admin interface of this plugin to the other database optimizing plugin I had, so I'm switching to this plugin instead.
It does what it needs to do and as a bonus provides nice data on how much it's removed over time. Not necessary but a cute touch.
What's not to like about a plugin that cut the size of my database by two-thirds with no ill effects? It's been a couple days now and the site works great. I do suggest making a complete backup before using, but in my case the bckup was unneeded.
There may be other db plugins that offer a little more fine tuning of what is done to the database, but they also require more time and attention because you need to do the work manually each time you use the plugin. With this one you set a few parameters, including how many post revisions to keep, setup a schedule and you are done.
Also, this plugin is very well supported.
Than you, Rolf, for the development, maintenance, and support of this very useful plugin.
Works like a charm, but would be a plus if send report to email :)
Clean 37Mb of garbage in my DB. )
Not much to add. Oh yes, one thing ! Do a backup of your database BEFORE. It went all good for me, but you never know :)
This is worth using to get rid of the mile-long list of revisions on the edit screens for my pages.
One suggestion: Fix the wording of the option "logging on". I thought it had to do with being logged on to something. Only later I figured out that it means, keep a log.
Running great on the following platform / solution:
This plugin which basically cleans up your bloated database and trims all of the access off (which also promote faster database access), has raised to bar by offering continuous upgrades to an involving refined set of features. Let me list the enhancements since my last review:
· Has incorporated logging - This now allows a method of tracking historical information to be used to help trouble shoot a problem in database integrity. The log file can be also used to help establish better procedures in publishing and management of: content, media and plugins now that a log may be archived. Secondly, your ability to analyze the log will help validate to the client, that you are aware of infrastructure issues. The is no way to print the log, although you can copy/paste it from the popup.
· Better admin interface - 2.2.4 sports a subtle improvement if the interface. It is intuitive and has a better overall interface. You can now step back to the config, then back again to the trimming the database with convenience. And improvement would be to additionally add: "Click HERE to go to the optimizer" button at the bottom of the page next to "Save Options."
· Schedule Optimization - You may select to perform automated scheduled optimizations built on the configuration you set by: Hourly, Twice Daily, Weekly and Twice Weekly
· Exclude Database Tables from Optimization: CHECKED TABLES WON'T BE OPTIMIZED! Primary used is to isolate tables from batch optimization. Usually all tables would be optimized
After the process of optimizing you are presented with the stats. I did not understand, "TOTAL SAVINGS SO FAR." At what point is the total saving being counted? I would suggest that it states, "From your last optimization." If that was done, it would be cool if the date of the last optimization was available. Ex: TOTAL SAVINGS SO FAR: xxxxxx from: ()date.
This is a 5 star plus rated plugin and I would recommend it to anyone who is a casual to a serious WordPress author/admin. The quality of work, attention to details and the quality/timely responses by this author, helps to promote any premium plugin which he offers.
See complete review for this plugin at: http://talkingmanuals.com/wordpress-plugins-reviews/wordpress-optimizers
You must log in to submit a review. You can also log in or register using the form near the top of this page.