openinteract-help

[Openinteract-help] sessions table filling up

[Chris M. <Chr...@te...>]

Hello,

At present the vast majority of users visiting my site are not logged in.  I
noticed that my session table fills up very quickly.  The site's been live
since mid-January and my session table was huge - almost a gig - I can't
tell exactly because it ate my disk space and corrupted the table.  Any
ideas about why this is happening?  Is clearing the session table something
that I'm supposed to do?

Thanks,

Chris McDaniel

Re: [Openinteract-help] sessions table filling up

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> At present the vast majority of users visiting my site are not logged in.  I
> noticed that my session table fills up very quickly.  The site's been live
> since mid-January and my session table was huge - almost a gig - I can't
> tell exactly because it ate my disk space and corrupted the table.  Any
> ideas about why this is happening?  Is clearing the session table something
> that I'm supposed to do?

Yes. Version 1.56 includes (among other things) an update to the 'base' 
package with a script 'cleanup_sessions.pl' which will delete old/stale 
sessions from the database. If you don't want to upgrade you can just 
grab the script from CVS and use it -- there aren't any other dependencies.

Sorry about the troubles it caused. It was definitely a deficiency 
before. OI will also create sessions more readily than it used to (even 
if people don't login) since we cache theme and other objects there.

Chris