We are using AWS Aurora MySQL and we recently moved to MySQL 5.7 version. After moving to this version, we started seeing issues with DDL statements. The processes which are running these statements just hangs in state "Waiting for table metadata lock". This behavior is intermittent. We never saw this issue with old MySQL version. Is anyone else also facing same problem and resolved it somehow?

Thanks, Sagun

  • Enable General Log and obtain all queries sent by client while executing some DDL, including query which hangs. Show query and log... – Akina Dec 19 '18 at 20:15
  • This stackoverflow link is talking about different problem. – sagun Dec 20 '18 at 20:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.