MySQL hint Lock wait timeout exceeded solution

Use show processlist to view problems

Cause: The reason is that when you use the InnoDB table type,
Default parameter: Innodb_lock_wait_timeout set the lock wait time is 50s,
Because some lock wait more than this time, so the wrong.

You can take this time longer, or optimize the stored procedures, the transaction avoids too long waiting.

There are two solutions :

First: Innodb_lock_wait_timeout lock wait time to change the big

My.ini file:

The code is as follows	Copy Code
#innodb_lock_wait_timeout = 50 Amended to Innodb_lock_wait_timeout = 500