MySQL Procedure causing Dead Lock
- by Phanindra
I am using MySQL server 5.1.45. And I am having a procedure with huge business logic. With less number of invocation of this procedure, my application is working fine, but when the number of invocations are getting increased this procedure is throwing Lock wait timeout exception.
My Question is will Procedure creates temporary tables…