wp_woocommerce_session_activity vs wp_woocommerce_sessions

  • Resolved dailce

    (@dailce)


    2 years, 10 months ago

    Looking at the database. I see we have wp_woocommerce_session_activity and wp_woocommerce_sessions.

    I went into Woocommerce > Tools > and cleared sessions. I think this clears wp_woocommerce_sessions – correct?

    Our wp_woocommerce_session_activity table is quite large: 150MB (1.8 million rows). I can’t seem to find information on this table, is it related to wp_woocommerce_sessions?

    Can I simply empty wp_woocommerce_session_activity via myphpadmin?

    • This topic was modified 2 years, 10 months ago by dailce.
    • This topic was modified 2 years, 10 months ago by dailce.
Viewing 3 replies - 1 through 3 (of 3 total)

  • @dailce

    Database modifications can cause issues so it’s recommended you use the Clear transients feature instead using the tool: in

    Dashboard > WooCommerce > System Status > Tools > Clear all

    Thread Starter dailce

    (@dailce)

    There isn’t a “Clear All” button…. but what is the wp_woocommerce_session_activity table for? I cleared sessions and trainsients and expired transients. But wp_woocommerce_session_activity is still full. Wonder if this large table affects performance at all.

    Hi @dailce!

    I checked on my test site, but I don’t have a wp_woocommerce_session_activity, only a wp_woocommerce_session.

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

    Once you’ve done that, paste it here in your response.

    Also, I’d recommend installing the WP Crontrol plugin available at:

    https://www.ads-software.com/plugins/wp-crontrol/

    Once it’s installed, you can go to Tools > Cron Events to see if there are any errors or messages related to the Wp-cron system.

    You could also check your WooCommerce > Status > Logs to see if there are any fatal-errors.

    If you find anything, share them with us too, together with your System Status report!

    I hope to hear from you soon!

    Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_woocommerce_session_activity vs wp_woocommerce_sessions’ is closed to new replies.