After downloading a backup of my database in phpadmin (gzipped) I finally noticed that the database was getting massive – 148mb on a site with less than 1,500 posts.
Poking through the database I noticed it was filled with the post’s revision histories; a few select posts had over 3,000! Finally I had a grand total of over 77,000 just filling the database.
Once cleaned out it had shrunk to under 8mb (uncompressed). Now, it seems to me that this is not a sane way to handle revisions and very little mention about cleaning or possible bloat of the database. Or am I the crazy one?
- The topic ‘Massive bloat of revision history’ is closed to new replies.