000---000 Posted June 10, 2009 Share Posted June 10, 2009 Hi, I think my database is running slower than it should. I have looked through some of the tables and the sessions table has over 250,000 entries in it. Simple question... can a clear this. is Click "empty" in phpmyadmin. Will this speed things up? The sessions table is about 130Mb. I assume clearing this will remove all shopping carts that haven't checked out. Is there anything else I will lose? Thanks. Matt Link to comment Share on other sites More sharing options...
Nullachtfuffzehn Posted June 10, 2009 Share Posted June 10, 2009 You can clear the table. Only thing that could ahppen is that someone who's actually shopping will loose his cart and session_id. Link to comment Share on other sites More sharing options...
MrPhil Posted June 11, 2009 Share Posted June 11, 2009 To avoid killing off live sessions, perhaps you can use an SQL query to delete only old rows. In the sessions table there is an "expiry" field which I think is a timestamp. Pick a timestamp more than a day or two old and delete every row with an older "expiry". You can use http://www.4webhelp.net/us/timestamp.php to get the number for "expiry". And of course, back up your database first (at least, until you've done this once or twice and know if and how it works)! Does anyone have an idea why this table would build up an accumulation of old sessions? Isn't it supposed to clean itself out? Link to comment Share on other sites More sharing options...
and Posted February 14, 2010 Share Posted February 14, 2010 ... Does anyone have an idea why this table would build up an accumulation of old sessions? Isn't it supposed to clean itself out? Good question MrPhil. Anybody knows the answer? Can I set somehow, that every session older than e.g. one week is automatically deleted? I would appreciate it. Link to comment Share on other sites More sharing options...
and Posted February 14, 2010 Share Posted February 14, 2010 Does anyone have an idea why this table would build up an accumulation of old sessions? Isn't it supposed to clean itself out? ok, I found some comprehensive information under: http://www.oscommerce.com/forums/topic/146031-clean-up-sessions-table Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.