Database

View All Threads First Prev Next

MySQL Table Lock Question Richard Andrew x6429-Jan-13 12:46 Richard Andrew x64 29-Jan-13 12:46  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. Re: MySQL Table Lock Question Jörgen Andersson30-Jan-13 10:34 Jörgen Andersson 30-Jan-13 10:34  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.

Last Visit: 31-Dec-99 18:00     Last Update: 21-Apr-18 21:24 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.