@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.
Kenin
(@kbassart)
Automattic Happiness Engineer
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?
