Stored Sessions Table is HUGE

Store Builder Questions
1

I have this store that does not get too much traffic and I 'm having trouble updating it. Trying to go from 4.17.1 to 4.17.2 results in a stalled site that does not update. It just closes the storefront and is stuck on “Processing”

So I went into the database to see if there is some issue there. I found that the Stored_sessions table is over 592MB (out of a total of a 650Mb database) with 1,6 million records… That’s the only inconsistency I found so I wonder if clearing this table would help with completing the update. Is it safe to delete all records? Is there another procedure to do that?

2

Hi!

You can decrease the value of the session storage live time, which is stored in the SESSIONS_STORAGE_ALIVE_TIME constant in the config.php file. You can decrease it from two weeks to a lower value. This will remove some of the older sessions stored there.