maria-discuss team mailing list archive

[mariadb@xxxxxxxxxxxxxx]

Can someone fill me in as to what's happening behind the scenes when a 
thread has the state "Unlocking tables?"

I looked here but did not see it listed:

https://mariadb.com/kb/en/library/general-thread-states/

Specifically, I sometimes see threads spending a lot of time in this 
state, and am looking to do some troubleshooting as to the cause of the 
delay. I.E., what could cause a thread to be delayed while in that state.

They're (currently) MyISAM tables if it makes a difference.

Thanks!

Dan