Tried to reduced database size but database is still the same size?

  • Resolved matt-tyas

    (@matt-tyas)


    12 years, 9 months ago

    Hi and thanks in advance for any help you can give me.

    I have a 100mb database limit on a site of mine. It has got up to about 66mb and I have decided to try to clear some space. I read that I needed to clear the post revisions. The blog has about 900 posts, and therefore a lot of revisions it does not need. I installed the, ‘Better Delete Revisions’ plugin. Ran it and it said it had removed 8000+ revisions.

    However when i log in to my host (1and1) to check the DB size it is still the same (about 66mb) although in PHPmyadmin in the WP_Posts table I can no longer see any Post_type revision. The wp_posts table is still 54mb according to PHPmyadmin however.

    I would like to be sure I have cleared some space really as I do not know what will happen when I reach the 100mb limit?!

    Thank you.

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

  • 1. if your host has PHPMyAdmin, try to optimize all database table.
    2. disable or limit wordpress the revisions feature with wp-config.php
    3. usually plugins which offer LOGS eat database space (like visitor stats).

    Thread Starter matt-tyas

    (@matt-tyas)

    Hi,

    Thanks for this, I did not know I needed to optimize to claim the space back. That has done it.

    Thanks.

    your welcome.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Tried to reduced database size but database is still the same size?’ is closed to new replies.