mysql python 查询超时_Python:MySQL:处理超时

我遇到了神秘的“MySQL服务器已经消失”错误，下面是我的解决方案。

此解决方案将允许您通过MySQL错误重试，处理几乎所有类型的查询，在查询str或单独的元组中包含查询变量，并收集和返回一路上遇到的所有成功和错误消息：def execute_query(query_str, values=None):

# defaults

num_affected_rows = 0

result_rows = None

success = False

message = "Error executing query: {}".format(query_str)

# run the query

try:

mysql_conn = get_existing_mysql_connection()

cur = mysql_conn.cursor()

if values == None or len(values) < 1:

num_affected_rows = cur.execute(query_str)

else:

num_affected_rows = cur.execute(query_str, values)

result_rows = cur.fetchall() # only relevant to select, but safe to run with others

cur.close()

mysql_conn.commit()

success = True

message = "Mysql success for query: {}".format