Search code examples
mysqlwordpress

can we delete wp_woocommerce_sessions from database?


My website is going down every morning ! i have contacted hosting people they said "The reason of suspension here is because the hosting service have exceeded the database limit of 1GB ,As part of our terms and conditions, we need you to make sure you will not go over the limit of 1GB database"

I checked in database i have table name called 'wp_woocommerce_sessions' size of 1.2 Gb

I have no idea that i can delete this table or not , please anyone let me know can i delete this table ? or please also let me know what is the use of this table in my wordpress site


Solution

  • 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.