smf_sessions

[domeen]

Hello,

I have a very busy site, and I checked if everything is correct, and I saw that the sql tabel:smf_sessions   is 1Gb..... Can I empty that table?

[Ken.]

Sounds like a question for the SMF forums domeen because it's an SMF table.

[ianus]

Greetings!

Yes, this is a know problem with SMF 1.1.x
I can give you a link to a german solution and try to translate the interesting parts.

1.) You can delete the contend of the sessions table (not the table itself)
->sideeffect: all users have to log in again.

2.)
Workaround:
In index.php insert after

Code Select Expand

// Start the session. (assuming it hasn't already been.)
loadSession();

this

Code Select Expand

sessionGC();



Than make the sessionGC-Funktion in Load.php more usefull

Change:

Code Select Expand

DELETE FROM {$db_prefix}sessions

to

Code Select Expand

DELETE LOW_PRIORITY FROM {$db_prefix}sessions

This will delete all sessions if the DB has "not much to do"


Original thread:
http://www.simplemachines.org/community/index.php?topic=80805.msg922769#msg922769

I will not take any response. Use at your own risk and please backup first.
I have changed my SMF this way, and for me, it works and keep the sessions table small.

[domeen]

so first I empty the table and then the workaroun? so if I do the workaround, the smf_session table  will be small in the future?

[G6Cad]

ypu got the link to the discussions on this issue on SMF, i suggest you browse there and read the topic he linked to.
This issue is pure SMF and have nothing to do with TP what so ever