I discovered this plug-in by fluke last night as I was Googling WordPress plug-in problems. Basically this plug-in helps to clean up and identify plug-in problems so you don't have to go search for them manually. It has a majority of great reviews, although one review says it crashed the person's Website. So note of caution here: Please make a back-up of your Website before you use the plug-in. You should be doing regular back-ups anyway.
http://wordpress.org/plugins/wp-optimize/
This is a summary of what it does:
- Every-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copies of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes that's on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing unnecessary post revisions from the database. For example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.
- Similar to the scenario described above, there might be thousands of spam and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click
- WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces
- Automatically cleans database every week and respects the "Keeps selected number of weeks data" option.
Source:
http://wordpress.org/plugins/wp-optimize/
