MySQL: Slow Drop table command

I'm trying to use

DROP TABLE IF EXISTS <myTableName>;

however, even after a few hours it still works. Any suggestions on a workaround?

+4
source share
1 answer

I had the same problem and it just resolved by restarting the server:

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start

Perhaps some kind of lock was delayed and a restart was released.

+6
source

Source: https://habr.com/ru/post/1546603/


All Articles