MySQL Forums
Forum List  »  Connector/Python

Re: Mysql and python thread (Access Denied problem)
Posted by: Michael G. Zinner
Date: June 03, 2005 08:03AM

A single MySQL connection can only handle one command at a time (at least in the C API). So if you have 2 threads executing statements against the server concurrently you need to use two seperate connections, or you will run into serious issues.

In the MySQL Query Browser we "clone" the master connection for each thread. Or, when the user is working in a single transaction, we must synchronize the threads so that one thread gets the connection at one point in time.

Hope this helps,


Michael Zinner, Team Lead, Developer Tools

Are you MySQL certified?

Options: ReplyQuote

Written By
Re: Mysql and python thread (Access Denied problem)
June 03, 2005 08:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.