SAE下使用MySQLdb 常常报错 OperationalError: (2006, 'MySQL server has gone away')，MySQLdb 下木有max_idle_time 肿么办？

推荐学习书目

› Learn Python the Hard Way

Python Sites

› PyPI - Python Package Index

› http://diveintopython.org/toc/index.html

› Pocoo

值得关注的项目

› PyPy

› Celery

› Jinja2

› Read the Docs

› gevent

› pyenv

› virtualenv

› Stackless Python

› Beautiful Soup

› 结巴中文分词

› Green Unicorn

› Sentry

› Shovel

› Pyflakes

› pytest

Python 编程

› pep8 Checker

Styles

› PEP 8

› Google Python Style Guide

› Code Style from The Hitchhiker's Guide

This topic created in 5014 days ago, the information mentioned may be changed or developed.

MySQLdb

报错

下木有

5 replies • 1970-01-01 08:00:00 +08:00

mercurylanded

Jan 6, 2013

http://saepy.sinaapp.com/topic/2/sae-%E9%94%99%E8%AF%AF-operationalerror-2006-mysql-server-has-gone-away-%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%B3%95

google一下

VYSE

Jan 7, 2013

拿到cursor前conn.ping一下，断了的话就自动重连了

http://www.neotitans.com/resources/python/mysql-python-connection-error-2006.html

ElmerZhang

Jan 7, 2013

set wait_timeout=xxxx
设置闲置连接超时时间

barbery

Jan 7, 2013

@mercurylanded 谢谢回答，你这个文章我看过，不过就像我标题所说 MySQLdb 下木有max_idle_time 。
@VYSE 灰常谢谢！！！貌似是正解！！！
@ElmerZhang set wait_timeout=xxxx 我看了手册：http://mysql-python.sourceforge.net/MySQLdb.html 找不到这个属性啊亲

ElmerZhang

Jan 7, 2013

@barbery 这是一条 SQL 语句

SAE下 使用MySQLdb 常常报错 OperationalError: (2006, 'MySQL server has gone away')，MySQLdb 下木有max_idle_time 肿么办？

SAE下使用MySQLdb 常常报错 OperationalError: (2006, 'MySQL server has gone away')，MySQLdb 下木有max_idle_time 肿么办？