WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Size of MySQL database (11 posts)

  1. xinxin
    Member
    Posted 8 years ago #

    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?

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    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.

  3. xinxin
    Member
    Posted 8 years ago #

    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?

  4. Mark (podz)
    Support Maven
    Posted 8 years ago #

    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 :)

  5. xinxin
    Member
    Posted 8 years ago #

    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.

  6. brittanie
    Member
    Posted 8 years ago #

    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:
    http://codex.wordpress.org/WordPress_Site_Maintenance

  7. xinxin
    Member
    Posted 8 years ago #

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

  8. gutielua
    Member
    Posted 7 years ago #

    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?

    Regards
    @

  9. Mark (podz)
    Support Maven
    Posted 7 years ago #

    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.

  10. gutielua
    Member
    Posted 7 years ago #

    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.

    @ndrés

  11. gutielua
    Member
    Posted 7 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic