Title: mysql databases full!
Last modified: August 19, 2016

---

# mysql databases full!

 *  [bombora](https://wordpress.org/support/users/bombora/)
 * (@bombora)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/)
 * Hi, my webhost only supports 100mb mysql databases, recently one of my blogs 
   has gone over so now I can’t post to it! Another one of my blogs is nearing this
   point. What can I do?
 * It doesn’t seem right to me as there is under 1,000 blog posts on each blog, 
   they’re not that big.

Viewing 12 replies - 1 through 12 (of 12 total)

 *  [mrmist](https://wordpress.org/support/users/mrmist/)
 * (@mrmist)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949558)
 * That does sound quite large. Have you got phpmyadmin? Can you see what the large
   tables are?
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949560)
 * 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.
 *  Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/)
 * (@otto42)
 * WordPress.org Admin
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949562)
 * 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.
 *  Thread Starter [bombora](https://wordpress.org/support/users/bombora/)
 * (@bombora)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949582)
 * 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?
 *  Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/)
 * (@otto42)
 * WordPress.org Admin
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949607)
 * 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.
 *  [mrmist](https://wordpress.org/support/users/mrmist/)
 * (@mrmist)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949617)
 * Or try a manual `delete from wp_comments where comment_type='spam';`
 *  Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/)
 * (@otto42)
 * WordPress.org Admin
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949624)
 * 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.
 *  [mrmist](https://wordpress.org/support/users/mrmist/)
 * (@mrmist)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949627)
 * 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.
 *  [mrmist](https://wordpress.org/support/users/mrmist/)
 * (@mrmist)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949628)
 * In fact even after that it still sounds odd, unless the sites are constantly 
   getting and dumping a whole load of spam.
 *  Thread Starter [bombora](https://wordpress.org/support/users/bombora/)
 * (@bombora)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949741)
 * 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.
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [17 years, 4 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949743)
 * If you can, set up a cron job to run that daily instead.
 *  [brockangelo](https://wordpress.org/support/users/brockangelo/)
 * (@brockangelo)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949878)
 * 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/](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…

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘mysql databases full!’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [full](https://wordpress.org/support/topic-tag/full/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 12 replies
 * 5 participants
 * Last reply from: [brockangelo](https://wordpress.org/support/users/brockangelo/)
 * Last activity: [16 years, 11 months ago](https://wordpress.org/support/topic/mysql-databases-full/#post-949878)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics