Support » Fixing WordPress » Size of MySQL database

  • Resolved xinxin


    I have two websites / webspaces. One has five installs of WP and the size of the database is 4MB. This is fine because this site has 100MB of space and I am only hitting 65%.

    The other has one install of WP and the database is 4.43MB. As I only have 10MB in total for this site, size does matter.

    Is there anyway that I can “optimise” the database or can I cull some stuff to give myself a bit of breathing space?

Viewing 10 replies - 1 through 10 (of 10 total)
  • Mark (podz)


    Support Maven

    The optimal answer of course is to move hosts.
    In the db that matters are you only running the basic tables? No stats, spam collection type code? There’s nothing you can cull from a normal install- it’s all needed.

    Both sites are hosted by the same place. And the plugins are similar.

    The oversize db has these two large tables: wp_sk2_logs running at 1.1MB and wp_sk2_spams at 512k.

    Is it possible to delete these two tables and start again? If so how?

    Mark (podz)


    Support Maven

    Login > manage > Spam Karma 2
    Scroll to the bottom of that page and the reset options are there. If you keep phpmyadmin open in one window and that in another you can check effects. Much easier than messing with tables 🙂

    Thanks Podz, what would we do without you!

    The database has dropped to 2.77MB and I now have a teensy bit of breathing space.

    Isn’t it possible to also clean up the tables where comments have been deleted and old posts/links/ whatever are stored? Old as in things you aren’t using anymore. It might be piece by piece but you could clear up a bit more space.

    Look here:

    Thanks Brittanie, that looks like a useful page of reminders.

    Hi one of my database size 127mb and 15mb zipped. The questions is: what things that are incessary I can delete to reduce the size.

    stats? On your experience… what could be a razonable size for one database?


    Mark (podz)


    Support Maven

    They both sound quite large unless you have LOTS of posts.
    If you want a comparison I have ~2300 posts and ~7000 comments and my exported non-zipped db is just over 11MB.

    Stats you can reduce, you can empty the bad_behavior_log if you have one…

    I have other tables in mine but the only ones I back up are the core tables because should things go wrong they are the only ones that matter to me.

    Wow… well I backup everthing. I have 400posts & 50comments. The size total are 127mb non-zipped are 15mn zipped.

    What could be wrong? A post too large? Backup only the core?

    I gone a follow your advice.


    Well, I know what it’s the problem. The size of table for stats. Ther are too bigger.

    The plugin that cause this, are wp-shorstats.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Size of MySQL database’ is closed to new replies.