代码修改完毕,python setup.py install 即可,如果出现mysql_config找不到的问题。你还要修改setup_posix.py文件。
- hoterran@hoterran-laptop:~/Projects/MySQL-python-1.2.3$ git diff setup_posix.py
- diff --git a/setup_posix.py b/setup_posix.py
- index 86432f5..f4f08f1 100644
- --- a/setup_posix.py
- +++ b/setup_posix.py
- @@ -23,7 +23,7 @@ def mysql_config(what):
- if ret/256 > 1:
- raise EnvironmentError("%s not found" % (mysql_config.path,))
- return data
- -mysql_config.path = "mysql_config"
- +mysql_config.path = "/usr/local/mysql/bin/mysql_config"
- def get_config():
- import os, sys
|
编译通过,我们来试试添加的read_timeout这个参数。
conn = MySQLdb.connect(host = DB_SERVER,user = DB_USERNAME,passwd = DB_PASSWORD,db = DB_NAME, port=int(DB_PORT), client_flag = 2, read_timeout = 10) |
然后执行语句前,你试着把mysql用gdb hang住10s后,python就会异常抛错
- OperationalError: (2013, 'Lost connection to MySQL server during query')
- >/home/hoterran/Projects/dbaas/trunk/dbtest.py(18)()
- >mydb.execute_sql(conn, sql)
- (Pdb)
- --Return--
- > /home/hoterran/Projects/dbaas/trunk/dbtest.py(18)()->None
- > mydb.execute_sql(conn, sql)
- (Pdb)
- OperationalError: (2013, 'Lost connection to MySQL server during query')
- > (1)()->None
|