{"issue":{"milestone":null,"title":"Session data on database cleanup","created_at":"2011-08-19T14:47:03Z","user":{"id":991171,"login":"bitbucket-import","url":"https://api.github.com/users/bitbucket-import","gravatar_id":"2f9627b73e1e5257020c9c7cbcdd6610","avatar_url":"https://secure.gravatar.com/avatar/2f9627b73e1e5257020c9c7cbcdd6610?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"updated_at":"2012-01-01T20:18:49Z","state":"open","labels":[{"name":"Bitbucket New","color":"DDDDDD","url":"https://api.github.com/repos/EllisLab/CodeIgniter/labels/Bitbucket+New"}],"id":1442147,"html_url":"https://github.com/EllisLab/CodeIgniter/issues/101","closed_at":null,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"I think this is kind of a bug…\r\n\r\nThe thing is that if the sess_expire_on_close is set to TRUE, that session data from the database will not be cleaned until has passed the the sess_expiration time setted on the config.\r\n\r\nThis mean that if sess_expiration is set to 0, all the sessions that have been “expired on close” will stay on the database for 2 years…\r\n\r\nthat make lot of garbage…\r\n\r\nI'm now thinking about a possible solution... \r\nI think the way is to store the sess exipiration date in the database, but I don't know if this is good...\r\n\r\nI've posted this on http://codeigniter.com/forums/viewthread/182790/","number":101,"url":"https://api.github.com/repos/EllisLab/CodeIgniter/issues/101","comments":2,"assignee":null},"comment":{"created_at":"2012-01-01T20:18:49Z","user":{"id":763613,"login":"derekjones","url":"https://api.github.com/users/derekjones","gravatar_id":"bcf753700280546563d4a604e3a71060","avatar_url":"https://secure.gravatar.com/avatar/bcf753700280546563d4a604e3a71060?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"updated_at":"2012-01-01T20:18:49Z","id":3325783,"body":"The session library has some randomized garbage cleanup (_sess_gc); I could see the desire to disable that if you have an environment that is doing that during preset low-traffic hours, but I think it's fine and probably appropriate to have it in there for users who don't need to or don't want to think about it.","url":"https://api.github.com/repos/EllisLab/CodeIgniter/issues/comments/3325783"},"action":"created"}