python连接mysql多个数据库_如何在Python中的多个进程之间共享单个MySQL数据库连接...

如何创建一个数据库连接并让每个进程与它对话，以最小化每次迭代产生新连接的开销？在

下面是一些示例代码来说明我要做的事情：import multiprocessing

import os.path

import hashlib

import sys

VALID_EXTENSIONS = ('.JPG', '.GIF', '.JPEG')

MAX_FILE_SZ = 1000000

#Declare a global mysql connection

db = MySQLdb.connect(host="localhost",

user=config.mysql_user,

passwd=config.mysql_pass,

db=config.mysql_db)

def md5_file(fname):

try:

with open(fname) as fo:

m = hashlib.md5()

chunk_sz = m.block_size * 128

data = fo.read(chunk_sz)

while data:

m.update(data)

data = fo.read(chunk_sz)

md5_hash = m.hexdigest()

md5_file.queue.put((fname, md5_hash))

#DATABASE LOGIC

cursor = db.cursor()

cursor.execute(""