import sys
import time
import MySQLdb
db = MySQLdb.connect('localhost', 'root', 'root', 'sexample');
time.sleep(20)
# show processlist
# kill id
try:
print "before ping"
db.ping()
print "after ping"
except MySQLdb.Error, e:
print e # Will print "(2006, 'MySQL server has gone away')"
# Reconnect
db = MySQLdb.connect('localhost', 'root', 'root', 'example');
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
print cursor.fetchone()
Python MySQL Connect Idle Timeout
最新推荐文章于 2022-04-19 18:26:33 发布