It's perfect to optimize DB efficiently and works Grreeaatt!
I hope higly recommend it who wants to manage DB effectively and to make whose page so fast !
Does a good quick job without harming anything, settings are easy to understand - really like it!
I've been using this plugin since the 1.x versions in 2012 and never had a chance to review it.
Recently, I faced some problems with tables crashing, and it would happen as soon as I'd hit the Optimize button.
After exchanging several messages with Rolf, it became clear the issues were not related to the plugin; in fact, optimizing the tables can be done - more or less - by running a phpMyAdmin SQL command. These errors popped up when I'd optimize the tables via phpMyAdmin also, so the problem was elsewhere.
Rolf's feedback helped me find the culprit of these crashes and I can honestly say the plugin does its job without any problems.
Worked very well when I tried it, and allowed me to remove tons of revisions that were still around, dating from before I decided to set a limit to 5 revisions.
Good job, Rolf!
I am not sure why some of these neat little tools -- like this one [optimize database -- are not built into WP as default, but thanks to those thinking about us that create these.
Keep the creativity flowing!!!
Again, THANK YOU!!!
I love ease of use - website was instantly faster!
And, I really like scheduler
Small thing to notice - log file shouldn't be public visible
As someone who is new to blogging and WordPress within the last year, I kept thinking I was missing something...there had to be a way to purge so many revisions of each post that I had piling up. Finally, I started searching for a plug-in to do the trick and I am so grateful I found this. I was surprised how much DB space this freed up and it's nice to have it run automatically each week. I would highly recommend...something every blogger or website developer should have!
A lot of the other plugins dont work on an older version of WP, so i would first have to upgrade, make full backups, and... no wait, my diskspace is full.
Removed revisions and kept x versions that you indicate.
Found out most of my database was filled by a visitorinfo logging plugin called wassup.
Removed the data from the wassup via the wassup plugin.
But it still said 400 MB.
Then chose in this plugin to optimize the wp_wassup table, and my 400 Mb where freed up.
One minus: Did seem to optimize some tables, although i specifically excluded them... Needs to be looked at. Still 5 star for helping me save space. I can lower my subscription at my isp.
ran it and about 3 seconds cleared out 5,000+ revisions and saved 20 MB off the DB size. Excellent!
Tested this on a multisite/multi-network/buddypress set up - locally and online.
All good so far.
You must log in to submit a review. You can also log in or register using the form near the top of this page.