Re: Mysql and python thread (Access Denied problem)
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,
Mike
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Subject
Written By
Posted
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.