Title: wp_posts over 100MB?
Last modified: August 31, 2016

---

# wp_posts over 100MB?

 *  [dm_llc](https://wordpress.org/support/users/dm_llc/)
 * (@dm_llc)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/wp_posts-over-100mb/)
 * How could it be possible that my wp_posts table size is over 100MB when I only
   have two posts?

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

 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/wp_posts-over-100mb/#post-7228737)
 * The `wp_posts` table doesn’t just hold posts. it holds pages, menu items, media
   details, and more. It also holds auto-drafts, revisions, etc, and all of those
   take up space. If you’re concerned you can look at the contents of what’s in 
   the table and see for yourself. Everything will have a value set under `post_type`
   that will tell you what each row actually is.
 *  Thread Starter [dm_llc](https://wordpress.org/support/users/dm_llc/)
 * (@dm_llc)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/wp_posts-over-100mb/#post-7228840)
 * Thank you! The website was actually hacked! I cleaned the tables and will be 
   monitoring it. Thanks again!
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/wp_posts-over-100mb/#post-7228855)
 * Also, make sure you close backdoors as well.
    - [http://smackdown.blogsblogsblogs.com/2008/06/24/how-to-completely-clean-your-hacked-wordpress-installation/](http://smackdown.blogsblogsblogs.com/2008/06/24/how-to-completely-clean-your-hacked-wordpress-installation/)
    - [http://ottopress.com/2009/hacked-wordpress-backdoors/](http://ottopress.com/2009/hacked-wordpress-backdoors/)
 *  When you’re done, you may want to implement some (if not all) of [the recommended security measures](https://codex.wordpress.org/Hardening_WordPress).

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

 The topic ‘wp_posts over 100MB?’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [t-p](https://wordpress.org/support/users/t-p/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/wp_posts-over-100mb/#post-7228855)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics