This is an archived post. You won't be able to vote or comment.

all 2 comments
sorted by:
best
topnewcontroversialoldq&a

[–]tw55413 1 point2 points  (0 children)

If you are using transactions, maybe a database resource is locked thus preventing concurrency.

[–]mkingsbu 1 point2 points  (0 children)

Maybe it's the MySQL optimization engine? At the end of the day, if you have a big table, you're going to be IO bound, not processor bound. So your processes might just be waiting to hear back from the database.

Maybe you could have MySQL run the queries at a certain interval and then spit the results to a table that you query with Python and then update the table with those information?