Support » Fixing WordPress » MySQL taking up GBs of space!

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.