Table os_session

Luenissla

Hello everyone,

The table os_session is the largest table with 429 MB out of 599 MB size of the whole database.
Is it possible to empty the table completely without affecting the OS system?
Greetings and Merry Christmas

ntozier

Yes. But emptying the _session table will log out any people currently logged in and they will need to re log in.

Luenissla

Thanks for the quick reply.
Maybe it would be enough to delete the expired sessions.
Couldn't the system do it better automatically?
Surely a session with date session_expire "2020-10-27 14:25:48" is no longer needed???
Greetings

ntozier

My system cleans up sessions. Not sure why your isn't.

KevinTheJedi

@Luenissla

My apologies, I misspoke on my last post. Looking back at the code I see purging expired sessions is only called on actual cron jobs, not auto-cron. So with this in mind, you will need to setup a cron job and that will automatically purge expired sessions. You can follow this guide to setup a cron job, ignore all of the email setting stuff just focus on the RECURRING TASKS SCHEDULER sections:

https://docs.osticket.com/en/latest/Getting%20Started/POP3-IMAP%20Settings.html#schedule-polling

Cheers.

Daedalus01

KevinTheJedi Does it have to specify purging old sessions, or just any type of cron job?

I don't have anything set up because I noticed the same thing, so every so often I will run the following

delete from ost_session where session_expire < 'YYYY-MM-DD'

Although when I purged out over 10K dead sessions, my DB size only shrank by 2MB. I'm not sure how many sessions you have in there, but you can find out with

select count(*) from ost_session

Luenissla

thanks for the hint. I'll take a bite out of it.
Best regards

KevinTheJedi

@Daedalus01

Just a normal cron job that polls the api/cron.php file. We don’t have a way to specify certain actions. This might be something good for 2.0 though 🤔

Cheers.

Daedalus01

Not trying to hijack by any means, but I do have a recurring Cron job set and scheduled from when I was trying to do email polling ( didnt work right) and never took it out. So Cron does have an active task set to run every day at 5 am, but still having dead old sessions.

Edit---Because I'm blind and set the path to the cron file to be for my test system and not the production.