Session Table is huge - 500MB only 4 rows?

7 Jun 2011, 1:49 PM

#1

Zen Follower

Hi

Its a strange one that I have not come across before - I am running about 20/30 zen cart shops and this is the only one that is doing it!

The session MYSQL table has only 4 rows in it but is taking up 500MB of space OMG! I know

I empty table and all goes back -but this has happened twice now and I am not sure why or how or what to do about it?

Does anyone knows or have had this before or a fix

(changing session table from medium blog to small blog breaks it)

Version: v1.3.9c

Thanks
Sarah

7 Jun 2011, 3:35 PM

#2

Totally Zenned

Re: Session Table is huge - 500MB only 4 rows?

What add-ons do you have installed and are they storing information in the session?

7 Jun 2011, 5:30 PM

#3

Zen Follower

Hi Kuroi

Nothing unusual addons wise:

ceon sage pay
shopping cart total in header
simple categories tree

Thanks
Sarah

7 Jun 2011, 5:31 PM

#4

Zen Follower

oh and ceon url seo module

I think shopping cart total sin header is only one not using on other stores