Does the job!
By copytrans on September 2, 2024
I have used this plugin on 5 different multi-site wordpress and have achieved awesome results. Here's the best one:
- 13779 revisions deleted
- database size reduced from 297MB to 65MB = 22% of original size!!
- this lead to an 11% speed gain (server side execution time to generate the page)
- we had such good results, because we had no limit on the number of revisions per post a few years back. wordpress does not automatically clean the revisions. The revisions for a post, only get cleaned up when you actually work on a post. In our case we had revisions from 2015 that were still encumbering the database.
Those are the settings I used: Delete revisions of: POST, PAGE, USER_REQUEST, WP_BLOCK, WP_TEMPLATE, WP_TEMPLATE_PART, WP_GLOBAL_STYLES, WP_NAVIGATION, WP_FONT_FAMILY, WP_FONT_FACE
Delete revisions older than: 720 days
Maximum number of - most recent - revisions to keep per post / page: 25
Delete trashed items: YES
Delete spammed items: YES
Delete unused tags: YES
Delete transients: NO
Delete pingbacks and trackbacks: YES
Clear oEmbed cache: NO
Keep a log: YES
Optimize InnoDB tables: YES
Number of excluded tables: 0
I've reviewed the plugin's source code and tested it extensively and found out a few issues in the source code that I have shared with the maintainers. Overall, I think this plugin is safe to use, provided you backup your database before and that you fully understand what you're doing.
Don't do it :) You've been warned...
By ⠚⠁⠗⠇ (jarld) on May 9, 2024
I tested this on two different sites, one almost clean, another one well up and running. The same result on both of them. Misconfigured references in the database and wordpress error messages. Its no longer possible to save data to the database. This obviously also includes trying to install or unistall plugins. The website is dead in the water.
Been troubleshooting this for a while now, reading other users experiences with this plugin. The takeaway is that this is a kind of "Install and see how it goes" kind of deals.
Sitting here waiting to load in my backup, but guess what :)
This plugin used over 100.000 database-updates to run once. My webhost has a limitation on 100.000 udates pr. hour, so no backup goes back in for the next hour.
If for some reason one of your hobbies are to run head first (as fast as you can) into a brick wall, and by that I mean try to install this plugin........Pretty Please, with sugar on top, take a fresh backup :)
I consider Optimize Database an essential plugin for every website.
By Das Capitolin on May 2, 2023
Excellent
By wpprup (wppraesenz) on November 29, 2022
Perfect, simple, clear
By novakpeter on June 7, 2022
I like this plugin
By yevhenwordpress on July 8, 2021
TOP Plugin
By eerkan on April 17, 2021
Works as Scheduled
By Chris (justkeepdistance) on February 21, 2021
Good plugin but leads to ongoing time-out errors
By Plugins and Snippets (pluginsandsnippets) on November 22, 2020
added a spam user in my database and changed my home url
By kyurmshah on October 29, 2020