My table cscart_sessions has grown too huge and probably is hurting the performance.
I see the sessions as old as one year.
Is there a safe way to clear the sessions older than certain period and for unregistered users ?
For anyone facing the same issue. You can run the following sqls (use you own suitable timestamp value for expiry) :
<br /> delete from cscart_sessions where expiry <= 1378038432<br /> ```<br /> [s]delete from cscart_user_session_products where session_id not in (select session_id from cscart_sessions)[/s]<br /> <br /> Executing second statement will delete items from wishlist and abandoned carts, don't do that. I pissed off a lot of customers <img src="upload://n4syhXZrRhsStKvmS4jT3Mp2S3k.png" class="bbc_emoticon" alt=":(">
should be done automatically based on your SESSION_ALIVE_TIME (think that's the name) define.
ve experienced such problem.t remember row count. I truncated it.
My site is under development (so no customers see it) and I noticed great database size (about 200 Mb) 170 Mb was sessions table. Unfortunatly I don
But 2 days later I saw that this table has 30 Mb with 6 rows (!!!). After defragmentation it size reduced to 30 kb.
Is this some cs-cart bug or db problem?