db getting bigger

  • ketanco

    (@ketanco)


    10 years, 5 months ago

    i have a wordpress site for years now and naturally as i make more posts the database gets bigger and bigger.

    not that there are any problems but i was just backing up my database and saw that its size grew to 165 MB….

    1) so it this too much and what problems can it cause?

    2) is there a way to minimize db growth rate?

    3) if this size is normal after what size it may be a problem?

    4) also when i add a media to my post does it also make db bigger , because it is stored in somewwhere else…

    just asking ahead of time or want to make things more efficient

Viewing 2 replies - 1 through 2 (of 2 total)
  • catacaustic

    (@catacaustic)

    10 years, 5 months ago

    The first thing to do is check which tables are the largest. Normally I’d do that through phpMyAdmin, or which ever database management tool that your hosting company offers. Sometimes larger tables can be truncated (emptied), but you’d want to be sure that it’s all able to be removed safely before doing anything too drastic.

    And as always, take a full backup of the database before you do anything! Just in case. 🙂

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    10 years, 5 months ago

    Our database here on WordPress.org is starting to push 70 GB. You’re fine. 🙂

    You can indeed reduce the size of your database through things like OPTIMIZE ing tables and such, but realistically, unless you’re having actual speed issues, it’s likely just fine.

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

The topic ‘db getting bigger’ is closed to new replies.