Welcome Guest, Not a member yet? Register   Sign In
Why is the "ci_sessions" table type MyISAM?
#11

[eluser]WanWizard[/eluser]
I wonder if that is the real issue.

I have sites with a much higher hit rate, and I notice no delay whatsoever with MyISAM tables. The session table or one of them currently holds over 23700 records, with a gc probability of 10%.

MyISAM doesn't support concurrent write access. If your application uses session variables a lot, the standard CI session class updates the session record every time you modify a session variable. Which means that it is possible that inserts are being queued.
We use a modified sess_write() method, that skips the write. We do an explicit write after the page request has been processed and the output generated, so only one session update per page request. That reduced the number of update queries by over 90%.


Messages In This Thread
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-21-2009, 01:43 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-21-2009, 10:35 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-21-2009, 11:03 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-22-2009, 12:48 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-22-2009, 01:01 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 02-10-2010, 06:45 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 02-10-2010, 07:26 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 10:00 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 10:18 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 11:31 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 12:44 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 01:50 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 03:54 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 05:07 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 12:39 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 02:00 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 03:11 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 03:22 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 09:34 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 09-09-2010, 06:24 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 09-10-2010, 12:32 AM



Theme © iAndrew 2016 - Forum software by © MyBB