Within my database I've got the following tables :
elggsystem_log_1238540402
elggsystem_log_1241132402
elggsystem_log_1246402801
elggsystem_log_1249081201
etc... Would harm be done if I dropped them ?
Better still is there a way of removing them from within Elgg's interface..
Thanks in advance for any advice.
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
The users_sessions table is where Elgg stores the PHP session information. If you delete it you will log out all the users on your site. There should be garbage collection to clean it periodically, but I don't see that in place...
garbage collection does not clean it
this table is growing fast on my install elgg 1.6.1
more than 1490 records in one day and only two users have logged in the site
This is where PHP sessions are stored, so any unique user to your site will generate a new session. Elgg tells PHP to store session information in the database, but if it didn't, PHP would have created 1490 new files for them. This isn't a problem.
What is a problem is how PHP's native garbage collection deals with custom session storage--I have a hunch that it doesn't. More research will have to be done on this, and I'd imagine a garbage collection of our own will need to take place for the sessions to keep this table in check.
The PHP setup that comes with Ubuntu (and Debian?) is broken for custom php session storage. I believe with a proper configuration, session garbage collection works but I have never checked.
One more thing, do not fix the php settings for garbage collection if you have a ton of old sessions that haven't been cleaned out. That'll probably cause mysql to go bonkers.
i clean it by hand , thank you :)
- Previous
- 1
- 2
- Next
You must log in to post replies.