Database Growing – _wc_session

  • Chris

    (@lamordnt)


    12 years, 7 months ago

    After upgrading Woocommerce I am noticing that my database has grown uncontrollably. The wp_post_meta table and the wp_options table are both over 2mb which they never were before. At first, the wp_options table was over 15mb but I Was able to clean it up by going to “System Status” and using the clear all sessions button.

    It works for a few moments and then instantly the database starts growing again. I am at a loss for what to do. anyone else experience this or have any suggestions?

    http://wordpress.org/plugins/woocommerce/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Watch Teller

    (@watchteller)

    12 years, 7 months ago

    Me too…

    Thread Starter Chris

    (@lamordnt)

    12 years, 7 months ago

    Anyone have suggestions on this? In just 1 day my wp-options table has gone from 2mb to 34mb!!! Help!!!

    BerryReview

    (@rhalevy)

    12 years, 7 months ago

    Are you running Wp-Cron manually from the command line? That seems to not be clearing out the WC sessions. I am still trying to find a way to solve this… Had 3.9 million records of wcsessions

    Thread Starter Chris

    (@lamordnt)

    12 years, 7 months ago

    Not really sure what it means to run wp-cron manually. I wound up restoring my site to an older version but at some point will need to update. Hoping Woocommerce can work this out.

    Thread Starter Chris

    (@lamordnt)

    12 years, 6 months ago

    OK so I think I figured this one out. It was a bit easier than thought. In Woocommerce settings I did not have “clear cart when logging out” under the settings. Checked that and my DB seems to be under control.

    Watch Teller

    (@watchteller)

    12 years, 6 months ago

    @chris,

    Thanks you update here.

    Cheers.

    RgDesign

    (@rgdesign)

    12 years ago

    Hey Guys specifically @chris

    I have been reading up on this issue and can not locate the “clear cart when logging out” option that is mentioned above.

    Did this option go away in the newer versions? I am currently running 2.1.2 and getting ready to upgrade but I am getting a lot of 500 Internal server errors.

    Are these options now under the WooCommerce > System Status > Tools > Clear All Sessions button?

    I am also going to try adding this to my robots txt file to see if this helps keep my DB smaller http://wordpress.org/support/topic/a-lot-of-wc-sessions

    Any suggestions?

    Thanks!

    Thread Starter Chris

    (@lamordnt)

    12 years ago

    I have two sites, one running 2.1.3 and one running 2.1.6 and on both the clear cart when logging out option is gone. Neither site is having problems with the database size anymore so they might have fixed it with the never versions. I would suggest backing up your site then upgrading it to see if the newer version fixes your problem.

    John Dao

    (@tiggerlu)

    11 years, 7 months ago

    I’ve been investigating this issue for months, our wp_options table is in the gigabytes now.

    The problem is WooCommerce isn’t cleaning up after itself, and it’s related to the cron job not running. So easiest way to check is if you can run wp-cron.php from the outside (http), in my case we had accidentally blocked the port.

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

The topic ‘Database Growing – _wc_session’ is closed to new replies.