How “unlock tables” command work in MySQL
While working on MySQL locks, I have found one weird thing. I got one alert from Nagios that there are many queries which are locked. When I have checked “Show Processlist” I found that many queries were waiting for release read lock with below status. “Waiting for release of readlock” I have tried to run…