Unlocking tables if thread is lost

Question

http   dev mysql com doc refman 5 0 en internal-locking html  The following is the extract from the documentation   mysql gt  LOCK TABLES real table WRITE  temp table WRITE  mysql gt  INSERT INTO real table SELECT   FROM temp table  mysql gt  DELETE FROM temp table  mysql gt  UNLOCK TABLES    My question is that if I use this logic in the shell script code  and if the thread is lost  not killed  before it reaches  unlock tables  statement  how will I know that some tables are locked and how do I unlock tables manually

User · Answer

With Sequel Pro    Restarting the app unlocked my tables  It resets the session connection    NOTE  I was doing this for a site on my local machine

User · Answer

how will I know that some tables are locked    You can use SHOW OPEN TABLES command to view locked tables      how do I unlock tables manually    If you know the session ID that locked tables -  SELECT CONNECTION ID     then you can run KILL command to terminate session and unlock tables

User · Answer

Here s what i do to FORCE UNLOCK FOR some locked tables in MySQL  1  Enter MySQL  mysql -u your user -p   2  Let s see the list of locked tables  mysql gt  show open tables where in use gt 0    3  Let s see the list of the current processes  one of them is locking your table s   mysql gt  show processlist    4  Let s kill one of these processes  mysql gt  kill put process id here

[mysql] Unlocking tables if thread is lost

Examples related to mysql