I consider Optimize Database an essential plugin for every website.
I consider Optimize Database an essential plugin for every website.
Easy to use with great results
Plugin works exactly as described. Thanks! It was easy to configure and I especially like the ability to remove all revisions except for XX amount, which makes it great for cleaning up existing sites where you’ve reduced the number of revisions, but the database still contains heaps of older revisions.
Perfect, simple, clear
Works like a breeze!
Easy to use with great results
Plugin works exactly as described. Thanks! It was easy to configure and I especially like the ability to remove all revisions except for XX amount, which makes it great for cleaning up existing sites where you’ve reduced the number of revisions, but the database still contains heaps of older revisions.
Does the job!
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_FACEDelete revisions older than: 720 daysMaximum number of – most recent – revisions to keep per post / page: 25Delete trashed items: YESDelete spammed items: YESDelete unused tags: YESDelete transients: NODelete pingbacks and trackbacks: YESClear oEmbed cache: NOKeep a log: YESOptimize InnoDB tables: YESNumber 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…
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 🙂
Easy to use with great results
Plugin works exactly as described. Thanks! It was easy to configure and I especially like the ability to remove all revisions except for XX amount, which makes it great for cleaning up existing sites where you’ve reduced the number of revisions, but the database still contains heaps of older revisions.
Does the job!
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_FACEDelete revisions older than: 720 daysMaximum number of – most recent – revisions to keep per post / page: 25Delete trashed items: YESDelete spammed items: YESDelete unused tags: YESDelete transients: NODelete pingbacks and trackbacks: YESClear oEmbed cache: NOKeep a log: YESOptimize InnoDB tables: YESNumber 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.
I consider Optimize Database an essential plugin for every website.
I consider Optimize Database an essential plugin for every website.
Don’t do it 🙂 You’ve been warned…
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 🙂
Don’t do it 🙂 You’ve been warned…
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 🙂
Easy to use with great results
Plugin works exactly as described. Thanks! It was easy to configure and I especially like the ability to remove all revisions except for XX amount, which makes it great for cleaning up existing sites where you’ve reduced the number of revisions, but the database still contains heaps of older revisions.
