Support » Fixing WordPress » How to Understand WP and MySQL Database Size

  • Hello and thanks in advance. I’ve been trying to understand MySQL database size, to find out if my webhost is giving me enough space to house my future WordPress blog.

    My web host has a “hard limit” of 100 MB for the database size. (they won’t allow anything over that limit). My current WP blog, http://www.youthtopia.com, now has a database size of .23 MB, well under the 100 MB limit. But I would like to set up a new, much larger WP blog.

    –What affects the size of the database?
    –Is 100 MB enough space for a very active WP blog?

    Thanks again! … RB

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    I am pretty sure that 100MB is enough. My database just made it to 1.3MB right now, and I have 527 posts, 586 comments, and 233 entries in my “Bad Behavior” block log. At this time, my blog has been live for 14 months.

    Thread Starter rankbeginner

    (@rankbeginner)

    Thanks very much, macmanx.
    So I can assume that:

    1) the MySQL database size is based on

    size of WP set up files +
    size of posts (and comments etc.)

    2) If my blog does somehow get too big, I can delete posts and free up space ?

    Best wishes … RB

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    1. No, the database is only made up of your blog’s contents, such as posts, comments, and certain settings. The WordPress files reside on your hosting account’s local hard disk. They have no effect on database size.

    2. Yes, you can delete posts and comments. But, if you blog does surpass 100MB, then that probably means that it is very popular. In that case, I would recommend upgrading your hosting account, or finding a different hosting provider.

    On my blog, Bad Behaviour’s log is 2.3MB in just under a month..

    Any ‘tracking’ scripts (BadBehavior, CG-Referrer, SpamKarma, CG-AntiSpam, etc…) are the things that will suck up DB space pretty quickly — as will something like a reblogging script that just pulls RSS feeds and republishes them (effectively postings tens of posts per day)… then the posts themselves will start to add up.

    -d

    Bad Behaviour.
    Open the folder, look for
    bad-behavior-wordpress.php
    Open that, near the top are two lines which you can alter to this:
    // Log failed requests to the database.
    $wp_bb_logging = TRUE;
    // Log all requests to the database, not just failed requests.
    $wp_bb_verbose_logging = FALSE;

    Setting that last one to TRUE will cause very large logs to be built up.
    Setting the first to FALSE will cause no data to be written to the db and this does not affect BB at all either.

    100meg should be fine.
    The largest I have come across so far was ~220MB of which only ~60meg was posts / comments. And that blogger is phenomenally popular with commenters who can (and do) write 1000+ word comments.

    You have no worries 🙂

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘How to Understand WP and MySQL Database Size’ is closed to new replies.