My python application is doing update on columns of a large mysql table. I am running multiple instances of same application to make the update process faster. Suppose I have 13 lac records. I am running 13 instances of same application:
1st instance update: 0-1 lac
2nd instance updating : 1-2 lac
....
...so on..
When I am running my code, I am getting following error:
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
Can anyone please tell how can I correct this?