This table is collecting the sessions and it's getting bigger and bigger. Any damage if I'm truncating the table from time to time?
This table is collecting the sessions and it's getting bigger and bigger. Any damage if I'm truncating the table from time to time? |
Your daily cron is supposed to clear it every days I think?
In my daily cron job it says:
Deleted sessions: xxx |
You can also write your own cron that clears sys sessions daily, 2x day, weekly, etc. if dolphin doesn't do it with the default cron. I have had to write my own php file along with a cron to clear it because dolphin won't empty the sessions. It got huge and it was a pain manually doing it so I wrote a php file and added it to cron 2x daily. DialMe.com - Your One and Only Source For Boonex Dolphin Tutorials and Resources |
As for me, I run these two SQL requests from time to time:
DELETE FROM `sys_sessions` WHERE `sys_sessions`.`user_id` = 0;
DELETE FROM `sys_sessions` WHERE `sys_sessions`.`date` < 1303784178; !!! replace 1303784178 with the latest date to delete Life is a fatal disease, sexually transmissible - Virginity is carcinogenic! Ask here for vaccine. |