Dear friends,
Please help me to understand several LOCKing the same tables without
unlocking them between LOCKs. Imagine the following code:
LOCK TABLES t1 READ, t2 READ;
-- some hard select queries which need that other threads do not update tables
LOCK TABLES t1 WRITE, t2 WRITE;
--
:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 2:29 PM
To: mysql@lists.mysql.com
Subject: Help me to understand multiple locking the same
tables (lock; lock; unlock)
Dear friends,
Please help me to understand several LOCKing the same
tables without
unlocking them between LOCKs