Today I see an mysql error in my apache log that I never faced before.
|
1 |
InternalError: (1205, u'Lock wait timeout exceeded; try restarting transaction') (10 additional frame(s) were not displayed) |
After lot of research I found solution. We can set variable innodb_lock_wait_timeout=100 for lock time to 100 sec.
|
1 |
set innodb_lock_wait_timeout=100 |
0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;">
