python - 为什么在更改超时变量后，Amazon RDS 上的 MySQL 不断使我的连接超时？

Question

我通过亚马逊的RDS服务租用了MySQL数据库。我设法习惯了数据库并可以用 Python 操作它。我正在尝试设置连接 MySQL 数据库的超时时间，但没有成功。我通过 Python 连接 MySQL 数据库总是在 10-11 分钟超时。

要编辑 MySQL 服务器的超时值，您需要访问其配置文件。我查看了 Amazon RDS 文档，并了解到 Amazon 这是通过“参数组”完成的。我创建了一个新的参数组，并将值:“connect_timeout”、“interactive_timeout”和“wait_timeout”分别设置为 1000000。我将数据库与此参数组关联，然后重新启动它。我用 Python 重新连接到数据库。大约 10 分钟不活动后，我的连接仍然超时。

除了在参数组中指定超时之外，我还尝试在 Python 中显式指定超时，但仍然没有成功。这是我尝试运行的代码:

import time
import mysql.connector
DataBase = 'DataBase'
Username = 'Username'
Password = 'Password'
Host = 'mydb.randomstring.region.rds.amazonaws.com'
cnx = mysql.connector.connect(
    user=Username, 
    password=Password, 
    host=Host, 
    database=DataBase,
    connect_timeout=1000000
)
mycursor = cnx.cursor()
time.sleep(900)
if cnx.is_connected():
    print('Database did not time out.')
else:
    print('Database timed out.')

>>> Database timed out.

有人知道为什么会发生这种情况吗？

此外，如果我尝试在一段时间不活动后运行命令，而不是仅仅询问 Python 我的连接是否仍然打开，我会收到此超时错误。这是如果我尝试在不活动后发出命令时收到的错误:

>>> # Establish a MySQL connection and do nothing for about 10 minutes.
>>> sql = "INSERT INTO Table (value_1, value_2) VALUES (%s, %s)"
>>> val = ('A', 'B')
>>> mycursor.execute(sql, val)
Traceback (most recent call last):
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\connections.py", line 691, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\socket.py", line 589, in readinto
    return self._sock.recv_into(b)
ConnectionResetError: [WinError 10054] An existing connection was forcibly closed by the remote host

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<pyshell#4>", line 1, in <module>
    mycursor.execute(sql, val)
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\cursors.py", line 170, in execute
    result = self._query(query)
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\cursors.py", line 328, in _query
    conn.query(q)
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\connections.py", line 517, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
    result.read()
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\connections.py", line 1075, in read
    first_packet = self.connection._read_packet()
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\connections.py", line 657, in _read_packet
    packet_header = self._read_bytes(4)
  File "C:\Users\MyUsername\AppData\Local\Programs\Python\Python37\lib\site-packages\pymysql\connections.py", line 699, in _read_bytes
    "Lost connection to MySQL server during query (%s)" % (e,))
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([WinError 10054] An existing connection was forcibly closed by the remote host)')

Answer 1

我找到了解决方案。我要切换到 PostgreSQL。