Re: General Table Locking Question

2005-03-31 Thread Gleb Paharenko
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 <[EMAIL PROTECTED]> wrote: > I've got a good

General Table Locking Question

2005-03-30 Thread Scott Klarenbach
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