Can I detect locked tables?

MySQL database connector for Python programming

Brought to you by: adustman

Can I detect locked tables?

Forum: Open Discussion

Creator: Skip Montanaro

Created: 2002-08-16

Updated: 2012-09-19

Skip Montanaro - 2002-08-16

From one thread I might execute

c.execute("LOCK TABLE ...")

Is it possible to tell in advance from another thread that a particular table has been locked and what type of lock is held?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andy Dustman - 2002-08-16
  
  There's no way that I know of either using SQL or the C API. Even if there was, some other thread could grab the lock immediately after your test. OTOH, you can create a mutex on the Python side of things (thread.lock), in your application, but the same comments apply.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.