@ankrgyl
> every statement was executed in its own transaction.
I do not see any begin(), rollback() or commit()'s in your code. According to the mysql-python docs, http://mysql-python.sourceforge.net/FAQ.html#my-data-disappe..., autocommit is disabled by default. Therefore each of your workers appears to be operating inside one very large transaction and never actually committing anything to the database?
Can you clarify?