Re: Enforcing Isolation in MySQL database

2006-03-04 Thread Heikki Tuuri
Vinay, - Original Message - From: Vinay [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, March 02, 2006 12:20 AM Subject: Enforcing Isolation in MySQL database --=_NextPart_000_002C_01C63D51.B51315D0 Content-Type: text/plain; charset=iso-8859-1 Content

Enforcing Isolation in MySQL database

2006-03-01 Thread Vinay
Hello , I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the default isolation. Is the concurrency enforced automatically by the database or is there anything the application programmer has to do to make sure the data consistent. How does the REPEATABLE-READ resolve the

Enforcing Isolation in MySQL database

2006-03-01 Thread Vinay
- Original Message - From: Vinay To: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 5:00 PM Subject: Enforcing Isolation in MySQL database Hello , I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the default isolation. Is the concurrency enforced