That does sound quite large. Have you got phpmyadmin? Can you see what the large tables are?
It may be your post revisions taking up space.
Check your database (use phpMyAdmin if you can) and figure out which ones are the biggest.
I doubt post revisions, even for 1000 posts, could take up 100 meg. It’s just text, text compresses nicely.
I’d look at it with phpMyAdmin, see which table takes up the most space. Probably wp_options. Might be a fair amount of junk that needs cleaning. Look for rss_378b2db28ddn and similar entries. Those can be safely killed off.
Use phpMyAdmin to run optimize on those tables. That’ll clean up some space.
Ok it looks like it is the comments section (although I only have 371 comments, counting approved and in moderation). It is taking up 148.1 MB, it wont let me optimize either as it states: #1044 – Access denied for user: ‘dbo226704969@%’ to database ‘db226704969’
Don’t know what that’s all about… How could 371 comments possibly take up that kind of space?
Spam. Deleted spam can still take up space in the DB until it’s optimized away.
You’ll have to talk to your host to find out why you can’t optimize the tables. However, another way to dump that stuff is to export and then import the DB, if you have that level of access.
Or try a manual delete from wp_comments where comment_type='spam';
Even deleted rows take up space until you optimize the table (or new rows take their place).
Deleting a row in a database just marks it as deleted. It doesn’t free up the space used by that row.
True, but it sounds like his user can’t do the necessary optimize table.
It might be necessary to delete all the spam, then ask the web host to optimize the database.
In fact even after that it still sounds odd, unless the sites are constantly getting and dumping a whole load of spam.
Ok I contacted my host to get it optimized, that did the trick. I now have almost the whole 100mbs free. I get TONS of spam comments on these two blogs, so many that I have to do a delete from wp_comments where comment_type=’0′; every couple of days, guess it just needed optimized after this? Anyways thanks, thats all it took.
If you can, set up a cron job to run that daily instead.
I was having this same issue, so I decided it was time to write a plugin. It’s called “Delete Spam Daily”. If you are still having this issue, you can check it out here:
http://wordpress.org/extend/plugins/delete-spam-daily/
It doesn’t optimize the tables, but that would be a nice feature to add. I’ll look into that…
