MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: How to identify which connection has locked a particular table
Posted by: Rick James
Date: November 22, 2011 09:31AM

There is no direct way. But there is a pretty simple indirect way. Look at the "Time" in PROCESSLIST. Ignore any that are "Sleep". Find the connection(s) that are not "Locked", but have been running longer (according to Time) than any running connection(s).

Usually that algorithm leads to the obvious villain. Sometimes it can lead to more than one.

Caveat about Slaves: The Time in the SQL thread is deceptive. It may be the villain, or it may be a red herring. The Time is "how long ago this query started on the _Master_", hence it is a pretty good indicator of replication lag.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to identify which connection has locked a particular table
4684
Veerabahu Subramanian
November 21, 2011 07:50AM
Re: How to identify which connection has locked a particular table
1951
Rick James
November 22, 2011 09:31AM
Re: How to identify which connection has locked a particular table
2174
Veerabahu Subramanian
November 25, 2011 05:09AM
Re: How to identify which connection has locked a particular table
1991
Rick James
November 27, 2011 11:12PM
Re: How to identify which connection has locked a particular table
1533
Veerabahu Subramanian
November 28, 2011 12:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.