Joomla_Session Table is Out of Control: Clean Up?
-
-
- Terp
- Elite Rocketeer
- Posts: 1720
- Thanks: 23
-
(Yes, I posted my question in the J! forums).
...strange db issue related to the J!_session table. Normally, at least in theory, the sessions table should be mangaged by Joomla and automatically clear out older sessions, right?
I am in the process of migrating my sites and updating with more recent RT templates (teared up when I decided to update a few HiveMind-based sites lol), and I noticed that in one db, the Joomla session table is way, WAY out of control...accounting 99.3% of the nearly 500M db!
I assume is okay to manually clean out the table (and not delete the table itself, of course)?
Anyone else ever run into this issue? Perhaps I have a J! backend param set wrong?
(edit: and was just thinking that if it doesn't fix itself, perhaps I need to setup a cron job to empty the table every week or so?) - Last Edit: 10 years 11 months ago by Terp.
-
-
-
- Terp
- Elite Rocketeer
- Posts: 1720
- Thanks: 23
-
My "aha moment:"
public $lifetime = '999999'; public $session_handler = 'database';
That explains what happened...never changed when I migrated from a localhost dev site. I had no idea the impact it would have. :-[
-
-
-
- Joe Halleck
- Preeminent Rocketeer
- Posts: 5481
- Thanks: 68
- Never give up!
-
That is a good one.
That equals 694 days.
- Magento - phpBB3 - Kunena - RokBridge Specialist
No Secure Tab posts unless requested.
Use the Thank You and Life Preserver Buttons!
Your signature is also great place for setup details...help us help you!
-
Time to create page: 0.045 seconds