Re: Python thread insertion with MySQL

[joseph sheedy]

As you discovered, you don't want to share a connection between threads without locking it down. Is locking the connection a suitable solution? Otherwise, either create one connection for each thread, or create a connection pool which threads can pull a connection from. If threads aren't being launched rapid fire, you can often get away with creating new connections as needed, since MySQL connection happens so quickly.

Improving Python performance using threads is a tricky subject, since it has that pesky global interpreter lock (GIL).