Lock Tables??

[Bailee]

Hi All,
There is a process that open a single connection and insert into several tables, found in several databases. The tables are all MyIsam and the databases are owned by a single MYSQL instance. The process implements a sort of hot backup of the tables in a database while inserting into the other tables.
It does this by:
- issuing LOCK TABLES on all interested tables
- FLUSH TABLE
- copy the tables
- UNLOCK TABLES

After locking the first table, any other insert fails with the message:
"Table 'xxx' was not locked with LOCK TABLES".
Clearly, 'xxx' is not locked because it does not have to.

Thanks! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

MySQL locking is independent from the storage engine. It is deadlock free as we lock all tables that we plan to work with in a single lock statement. Only the locked tables can be used until the lock is released.
MySQL knows, which tables will be used throughout the command and locks all in a single go. At the end of the command the lock is released. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --