Small site w/ VERY LARGE _options table

  • Resolved RyanPrentiss

    (@ryanprentiss)


    9 years ago

    My _options table has 1,838,832 records, and is 1.16 GB in size. I have run WP_Optimize a couple times successfully removing all junk and transient records; however the _options table remains tremendously bloated, and I receive the following error for about 30 secs following each optimization attempt.

    Service Unavailable
    The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

    Any help in correcting my database issue would be greatly appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • David Uzelac

    (@daviduzelac)

    Hey there!

    Have you looked into this?

    https://premium.wpmudev.org/blog/optimizing-your-wordpress-database-a-complete-guide/

    Might help you optimize your database a bit better, let me know if any information there was useful to you.

    David_G

    (@questas_admin)

    Contact your hosting company, they might be able to help.

    Thread Starter RyanPrentiss

    (@ryanprentiss)

    Thanks for the help guys.

    After looking into the _options table I realized there are a LOT of cached cart records. I was able to clear the cache via Woocommerce -> System Status -> Tools -> Clear All Customer Sessions. This sent 1.16G of my 1.26G _options size to overhead which I was able to easily remove by rerunning WP_Optimize.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Small site w/ VERY LARGE _options table’ is closed to new replies.