2 messages in com.mysql.lists.mysqlRe: General Table Locking Question
FromSent OnAttachments
Scott Klarenbach30 Mar 2005 11:22 
Gleb Paharenko30 Mar 2005 17:57 
Subject:Re: General Table Locking Question
From:Gleb Paharenko (gleb@ensita.net)
Date:03/30/2005 05:57:40 PM
List:com.mysql.lists.mysql

Hello.

Every thing depends on logic of your application. But I don't see a big gain of using table-level locks on InnoDB. Among others this might be helpful:

http://dev.mysql.com/doc/mysql/en/internal-locking.html

Scott Klarenbach <doyo@gmail.com> wrote:

I've got a good deal of experience using mysql, but never in a large production environment with many concurrent users.

Using the InnoDB engine, what is the general practice for ensuring data integrity when multiple users are writing to the same table?

Should I explicitly lock the table before I write to it, or does mysql do this automatically?

Thanks, sk