<x-charset iso-8859-1>According to the docs (http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html) :
If a thread obtains a READ lock on a table, that thread (and all other threads) can only read from the table. If a thread obtains a WRITE lock on a table, only the thread holding the lock can read from or write to the table. Other threads are blocked.
So, I've got two threads going (T1, T2).
T1 issues LOCK TABLES transtest WRITE;
But when I go to T2, I can still issue: SELECT * FROM transtest; and retrieve all the data. I CANNOT update, so I know the command is at least partially working. As I understand it, I'm supposed to see a message from T2 that says something about "This table has been locked with the LOCK TABLES command."
Did T2 issue a LOCK TABLES transtest READ; or did you just try doing the read without trying to get a READ Lock? If the latter, then that is your problem. Once you start locking a table, EVERYONE needs to get locks on that table.
It is an InnoDB table, if that matters.
Thanks,
Lou
</x-charset>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
