Support

Admin Tools

#40489 Is there any way to set admin tools session cleaner to auto clear session table daily?

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
5.03
PHP version
8.2x
Admin Tools version
Latest

Latest post by tampe125 on Tuesday, 26 March 2024 08:52 CDT

MelanieB

Hi, 

I have finally identified one of the biggest causes of why our sites keep slowing right down and it seems due to very large session tables that seem to fill up quite quickly. I see admin tools has a session table cleaner and wondered if there is any way to set this to run automatically daily at a specific time?

Kind regards

 

Mel

MelanieB

Oh WOW!

Think I have found it! All these years I have been using Admin Tools and never looked at Site Maintenance tool. I believe this does the job. I just had to enable Optimise session? as this was disabled.

 

tampe125
Akeeba Staff

Hello,

yes, you're right, that's the correct tool to use. More info about it here: https://www.akeeba.com/documentation/admin-tools-joomla/auto-maintenance-session-repair.html 

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

MelanieB

Hi Davide,

 

thanks for your response and the helpful link. 

 

I am just investigating this further as mine isnt yet working correctly and also looking at my php settings.

 

If I want to run session cleaner every hour as suggest, should my session.gc_maxlifetime in PHP be set to 60, and not the default 1440? Should the session in Joomla configuration be set to 60 (or 30?) 

These were all different and when I checked after the hour the table hadn't cleared so i am guessing it may have something to do with the value in session.gc_maxlifetime?

 

Kind regards

MelanieB

Hi, 

 

an update, it works beautifully with the settings in my last message.

 

For anyone else who has these issues, I have it set to 60 in Joomla Session (filesystem), 1440 in php both on the server and withing php on each website. I do not have cache enabled on Joomla and it doesn't seem to impact performance. It now clears the session table every hour.

 

Thank you so much for this. So pleased. Wish I had found this tool sooner!

tampe125
Akeeba Staff

You're welcome!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!