擅长:python、mysql、java
<p>根据<a href="http://mysql-python.sourceforge.net/MySQLdb.html#functions-and-attributes" rel="nofollow">the documentation</a>:</p>
<blockquote>
<p>The MySQL protocol can not handle multiple threads using the same connection at once.</p>
</blockquote>
<p>这就是为什么它不起作用,你不能在线程之间共享一个数据库连接(至少对于MySQL是这样)。在</p>
<p>链接到的示例是为每个线程创建连接:</p>
<pre><code>for thread in range(threads):
try:
connections.append(MySQLdb.connect(host=mysql_host, user=mysql_user, passwd=mysql_pass, db=mysql_db, port=mysql_port))
</code></pre>