Re: Metadata Locks

[Rick James]

What DDL statements are you running?

What transaction isolation mode are you using?

SHOW VARIABLES LIKE 'innodb%';

What do these say when there is a hang:
SHOW ENGINE INNODB STATUS;
SHOW ENGINE INNODB MUTEX;