1
gravies
xoops session table is huge
  • 2005/5/21 2:27

  • gravies

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/8/18


My XOOPS session table is currently 45 Megabytes and has 435,000 entries!

Is this normal?

Can I get rid of some of these sessions? I seem to have multiple sessions per IP address. If yes - then what is the best way to do it? Empty the table with phpmyadmin? I tried optimizing but that didn't reduce the size.

I am using 2.0.10 and have upgraded from 2.0.7 sequentially.

2
jdseymour
Re: xoops session table is huge

No that is not normal. Do you use a custom session?, they can be manually deleted with no problem

3
davidl2
Re: xoops session table is huge
  • 2005/5/21 2:31

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


That's pretty huge!

4
gravies
Re: xoops session table is huge
  • 2005/5/21 2:34

  • gravies

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/8/18


Yes, I use a custom session to set the timeout to 2 hours instead of 15 minutes.

I now have the 2.0.10 autologin hack installed so I may not need the custom session. Thoughts?

I'll try emptying the table on a test site!

5
jdseymour
Re: xoops session table is huge

You do not need custom sessions with autologon. PHPmyadmin will work fine to empty the table

6
gravies
Re: xoops session table is huge
  • 2005/5/21 2:41

  • gravies

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/8/18


Presumably emptying the table is dangerous if people are logged in and adding forum posts or comments... when I empty the table they will be logged out?

There should probably be a mechanism in XOOPS core / db admin module to remove expired or old sessions...

Is there even a module that optimizes the tables? Is table optimization really that necessary? Too many questions = too little time!


7
jdseymour
Re: xoops session table is huge

I usually check mine every couple of days and optimize through phpmyadmin. the only danger (as I understand it) in emptying the table while users are logged in is that they may need to relogin. Since you have autologin, that will happen automagically with no user intervention.

8
knoedel
Re: xoops session table is huge
  • 2006/7/21 10:25

  • knoedel

  • Just popping in

  • Posts: 7

  • Since: 2005/10/14


Hmm... my session table currently has 900.000 records. I don't understand why it should be so hard to delete these old session-records automaticly...

Can anyone explain?? Or do I miss something.

9
knoedel
Re: xoops session table is huge
  • 2006/7/22 23:09

  • knoedel

  • Just popping in

  • Posts: 7

  • Since: 2005/10/14


Can anybody please help? I searched the forums, but found no anwser....

Login

Who's Online

184 user(s) are online (46 user(s) are browsing Support Forums)


Members: 0


Guests: 184


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits