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
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