MySQL Table Lock Question
-
I can't find the answer to this MySQL question in the documentation: If I execute "LOCK TABLES" through an ODBC connection, and a different thread already holds a lock on the specific table, does the calling thread block until the lock is acquired, or does the call simply fail and return immediately?
The difficult we do right away... ...the impossible takes slightly longer.
-
I can't find the answer to this MySQL question in the documentation: If I execute "LOCK TABLES" through an ODBC connection, and a different thread already holds a lock on the specific table, does the calling thread block until the lock is acquired, or does the call simply fail and return immediately?
The difficult we do right away... ...the impossible takes slightly longer.
I don't know the answer either. (I would assume it waits) But check if you can use named locks[^] instead, then your application can name the lock and check if another instance have made a lock with the same name or not. But watch out, there are a lot of pitfalls. So read the manual properly.
People say nothing is impossible, but I do nothing every day.
