MySQL taking up GBs of space!

  • Hi all,

    I’ve was informed by the hosting company I use that I’ve run out of disk space.

    On inspection, I can see the MySQL DB for a very simple 4 page site with taking up around 6GB of space. Specifically, wp_postmeta and wp-posts.

    There’s only a few post, that contain a few images, on the site, with no comments.

    If it wasn’t going to break the entire site, I’d happily Drop those 2 tables. WOuld it break the DB?

    Can anyone suggest a quick easy way to flush those tables?

    Many thanks in advance for any insight.

Viewing 3 replies - 1 through 3 (of 3 total)
  • jack randall

    (@theotherlebowski)

    if you have access to the server you might want to see what’s in your database that’s taking up all that space! if your site is light on content (no huge images or videos) then you shouldn’t be taking up 6GB on a database or in HDD storage. something is a bit fishy here…

    I am having the same issue…just had all data from online store site migrated over to a WP site I am building, eventually integrating the e-store into the showroom site. Was told by hosting company we are over the 300 MB limit, currently sitting at 2 GB, wp_postmeta(1.7 GB) and wp_posts(291.5 MiB). There are 478,872 rows. I need to reduce this, how can I do it? Don’t know much about Dbases.

    1.Delete unwanted plugins
    2.Delete spam comments and unwanted codes
    3.Compress images
    4. optimize your database. Using WP-DB manager or WP optimize plugin is a great way to restore, repair, optimize and backup your database.
    5.With a cache plugin, the generated page is stored on the server, so when a user visits a page for the next time, the same page is pre-generated and the database isn’t called in.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL taking up GBs of space!’ is closed to new replies.