Django数据库连接丢失的问题解决（示例讲解）

DATABASES = {

    "default": {

            'ENGINE': 'django.db.backends.mysql',

            'NAME': '',

            'USER': '',

            'PASSWORD': '',

            'HOST': '',

            'CONN_MAX_AGE': 9  # 比wait_timeout小一些

    }

}

# Register an event to reset transaction state and close connections past

# their lifetime.

def close_old_connections(**kwargs):

    for conn in connections.all():

        conn.close_if_unusable_or_obsolete()

signals.request_started.connect(close_old_connections)

signals.request_finished.connect(close_old_connections)

In[5]：from django.db import close_old_connections

In[6]：close_old_connections()

In[7]：list(User.objects.filter(id=1))

Out[7]: [<User: admin>]