1
disky
The xoops_session table
  • 2005/12/21 12:02

  • disky

  • Just popping in

  • Posts: 90

  • Since: 2003/10/31


What is the purpose of the xoops_session table in the database ?

On one of the sites i host: www.debian-news.net in the database the xoops_session table contains a stagering 139241 records !!!

So i have a few questions about this table.

What is the purpose of this table ?

Why does it keep growing ? Even if i disable 'Use custom session' in preferences !!

Can i just truncate the table without any ill effects, like once a week ?
Or maybe run a script that takes the 'Session expiration' and removes records that are to old ?

I am running on XOOPS 2.0.13.2

Best Regards
Søren Reinke

2
disky
Re: The xoops_session table
  • 2005/12/23 12:35

  • disky

  • Just popping in

  • Posts: 90

  • Since: 2003/10/31


Is there nobody here who know what this table is doing ?

3
Dave_L
Re: The xoops_session table
  • 2005/12/23 12:52

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


The sessions table keep track of various information that needs to be preserved across page requests.

What expiration time do you have set for the sessions?

What date/time range do the session rows span? You can determine that with this query: SELECT from_unixtime(sess_updated) FROM xoops_session ORDER BY sess_updated DESC

Deleting old session rows shouldn't hurt anything. If you delete a session row that corresponds to a user who's currently accessing the site, I think that would just log him out.

4
disky
Re: The xoops_session table
  • 2005/12/26 21:07

  • disky

  • Just popping in

  • Posts: 90

  • Since: 2003/10/31


Thanks for the clarification.

How come XOOPS does not clean up in these tables on its own ?

On another site www.xray-mag.com the timeout is 1 day, but there was session records from 2004 in the table.

Login

Who's Online

104 user(s) are online (57 user(s) are browsing Support Forums)


Members: 0


Guests: 104


more...

Donat-O-Meter

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

Latest GitHub Commits