Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 01-03-2020 14:41:58

Shopper
Member
Registered: 09-10-2007
Posts: 94

core_sessions with more than 13 million records

Today I found out, that the core_sessions table has more than 13 million records. I don't know why. Unfortunately we don't have so many customers. Can I empty this table?

Offline

 

#2 01-07-2020 09:10:14

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19525
Website

Re: core_sessions with more than 13 million records

Yes, you can empty this table.  I assume you're on a V8 or early K9 and may have the setting to store sessions set to forever (check System / Component / Settings / Cron Settings).  Later versions of K9 don't have this setting.  Execute these three statements one at a time in order to properly clean everything:

Code:

DELETE FROM core_sessions

UPDATE core_users SET lastsid=''

DELETE FROM ecom_cart

One or more of these statements may log you out if you execute them in Raw DB Admin, FYI.  If this happens, log back in and finish the rest.


Nick Hendler

Offline

 

Board footer