Huge database – wp_woocommerce_sessions

@millo_2k You can go to WooCommerce > Status > Tools and there is a button there to clear customer sessions. This should remove all sessions from the database.

These should automatically be being cleared. Is WordPres Cron working/enabled on your site? Under WooCommerce > Status, it should have a green checkmark in the first section. If this is not working, it could be part of the problem.

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Thank you for your advice. It worked 10000%!!

Hello,
I have the same problem – I disabled the WP_CRON in the wp-config.php, but I did set up a cronjob that calls this script every 15mins:

#!/bin/sh
wget -O - -q "https://www.domain.com/wp-cron.php?doing_wp_cron" > /dev/null
exit 0

But this one does not clear the wp_woocommerce_sessions table?

Thanks.

I spoke with Woocommerce support yesterday about this same problem. I previously used WP CRON and after a couple weeks when that failed to clear the wp_woocommerce_sessions I disabled WP CRON and used a server-side cronjob. But over the past 26 hours my table has gotten big again. It gets about 1 megabyte every 15 minutes, so I usually have about 100mb after 1 day.

Woocommerce support didn’t give me much help. They said I should install the WP Control plugin to monitor my cron. My cron is working fine and other plugins are working fine.

@wpchina: I spoke to WooCommerce support as well. I think the only solution is to handle sessions via Redis.

@torbentschechnegmailcom how can Redis solve it?

Is there a URL we can manually hit via a cronjob to clear the sessions?

@torbentschechnegmailcom I started a new thread here: https://www.ads-software.com/support/topic/wp_woocommerce_sessions-table-growing-very-very-large/