MySQLdb multithreaded

[Skip Montanaro]

    Bram> MySQLdb package claims thread-safety.  I am doing a lot of
    Bram> multithreaded queries, which give me crashes.  single thread is
    Bram> OK.

    Bram> Can I have multiple threads use the same connection to the db, or
    Bram> does each thread require its own connection?

Yes, but the connections can't be shared by multiple threads concurrently
(level 1, not level 2 concurrency I think, I forget the exact terminology
and numbers).  I hold several connections in a Queue.Queue() instance, pull
one out when a thread needs one, put it back when finished.  Works like a
charm.  The number of connections you place in the queue help to easily
limit the load on your database server as well.

Skip