Conceptually, SERIALIZABLE just adds LOCK IN SHARE MODE to every SELECT query. Other than that there is not much difference.
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Bill Todd [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 7:13 PM > To: [EMAIL PROTECTED] > Subject: Difference between Serializable and Repeatable Read with InnoDB > > > Since InnoDB does not allow phantom reads with Repeatable Read isolation > (which are allowed in the ANSI SQL definition of Repeatable Read) what is > the difference between these two isolation levels. Is it just > serialization > and that is all? > > Bill > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]