Welcome Guest, Not a member yet? Register   Sign In
Database sessions and garbage collection
#2

(03-08-2015, 09:34 AM)kozzleto Wrote: It's worth mentioning that I have an extra column `user_id`(int 20) in the `sessions` table to easily identify my online users.

This would be the first thing I would look at. My best guess would be that whatever you are doing to maintain the user_id in the session table is interfering with the session driver's maintenance of the sessions.

I would recommend using a reference table (user_id, session_id) for this, instead (with the user_id set as a unique value so you don't end up with multiple session_id entries per user). You could then use an inner join when retrieving the online users to ensure you only get session_id values which are in both tables.
Reply


Messages In This Thread
RE: Database sessions and garbage collection - by mwhitney - 03-09-2015, 11:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB