MySQL: Waiting for table metadata lock

Temporarily modify the fields of the database table , I met this problem , To put it bluntly, it’s the watch lock , As a result, it cannot be modified successfully .

SSH Remote to server , Log in to MySQL

mysql -uroot -plalalal

Then use the following command to see what you are doing:

show processlist;

Find a lot of sleep under the same connection

kill id;

Kill a few days later , It’s finally normal .

Similar Posts: