WordPress automatically saves pages that you edit, allowing you to go “back in time”, if you will, and while that’s a great feature, it can lead to problems.
If you change your site often, add or delete plugins, upgrade regularly, etc. – in other words, you do what you’re supposed to do, then WordPress can become too large for you to reliably and efficiently manage.
These database problems might be rare, but at best, they happen at inopportune times even if you’re very well prepared. At worst, if you’re not prepared, they can be catastrophic.
Take a look at this plugin I found called WP-optimize – It cleans up your database in seconds, and in doing so, I believe, making most DB nightmares a thing of the past.
It’s free, it’s fast, it’s easy, and it works. They get a “big thumbs up” from me, and yes, I did make a donation too 😉