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

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to