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

[eluser]waspfactoryuk[/eluser]
My understanding is that the key advantage of InnoDB here is that it has row level locking whereas MyISAM has table level locking. If you are updating a MyISAM table, the table is locked and reads are queued until the write is completed. With InnoDB, a write only locks the affected row so the remaining unaffected rows in the table can still be read.

If the site doesn't have a large number of concurrent users, there probably won't be much difference, but as soon as you have multiple users all trying to read/write the same table, it quickly becomes a bottleneck.

Yes, MyISAM may be quicker and InnoDB may enforce relationships, but these factors are irrelevant here. The issue as I see it is that MyISAM can only be quicker if the table you are trying to read from is not locked therefore InnoDB is a more appropriate choice for concurrent users.

Sorry to drag up an old post but there is not a great deal around on this subject.


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