Not the answer you need?
Register and ask your own question!

How to prevent Mysql routine procedure have "metadata lock wait timeout" lock the object ?

lokesh123lokesh123 Current User Role Patron
Event schedule to kill lock transaction does not help much?

Answers

  • vaibhav_upadhyay40vaibhav_upadhyay40 Contributor Current User Role Patron
    Hi @lokesh123
    I am trying to give high level or generic answer here,
    Basically rather than killing such transactions , check which transactions are causing this conflict.
    One you came across this situation, check the process list, innodb engine status and capture the set of transaction causing lock and conflict. From thereon you can try to improve the query, logic and my require code change depends upon the problem.



     

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.