sessions don't get deleted from sys_sessions

Sessions are not deleted from sys_sessions and by now I have over 1500 records in that table. Small detail is that this is not a live site and currently I am the only one using it, for testing.

Am I the only one with this issue?

Hi and I have this issue.  I have over 316,992 records in sys_sessions table and it is 61.7 MB. Is it possible to truncate it manually?

Lack of database pruning is a known issue, I already made a ticket a while ago.

To delete unwanted records, you can run such SQL request:

DELETE FROM `sys_sessions` WHERE `sys_sessions`.`date` < xxxxxxxxxx;

(replace xxxxxxxxxx with the first record's date you want to keep)

Maybe have a look at your tables bx_spy_data and bx_spy_friends_data too ;-)

DELETE FROM `bx_spy_data` WHERE `bx_spy_data`.`id` < xxxxxx;
DELETE FROM `bx_spy_friends_data` WHERE `bx_spy_friends_data`.`id` < xxxxxx;

yes it's a BIG trouble

Ticket was created - http://www.boonex.com/trac/dolphin/ticket/2095

Thanks MichelSwiss!

This made my database go from over 10MB to just 2MB.

What difference in size - yeesh!

I hope this gets fixed soon.

I should have read this thread sooner.  I just deleted over 25,000 records from this table.  I believe my pages are loading faster now.

2 years later and this has STILL not been fixed in Dolphin, what's up with that?

Is your cron job working? My sessions are deleted every night at midnight when the cron job runs.

yeah, I guess it is working, but there's a TON of other stuff that should be deleted from the database included in the cron. I just deleted probably close to 5 million useless entries, tons of crap from deleted members, etc...