pymysql 设置超时时间

pymysql 设置超时时间

1. 设置超时时间

import pymysqlfrom DBUtils.PooledDB import pooledDB_DB_POOL_ = {}db_dict = { "host": "127.0.0.1", "port": 3306, "user": "root", "passwd": "123456", "db": "utpdb", "maxconnections": 10, "charset": "utf8", "setsession": ['SET AUTOCOMMIT = 1'], "connection_timeout": 60, "read_timeout": 60, "write_timeout": 60,}def connect(db_name): if db_name not in _DB_POOL_: _DB_POOL_[db_name] = PooledDB(pymysql, **db_dict) db_pool = _DB_POOL_[db_name] return Conn(db_pool)

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。