mysql - 我如何强制 Xeround 关闭所有连接？

Question

我在 Xeround 上试验 SQLAlchemy:

>>> from sqlalchemy import create_engine
>>> engine = create_engine("mysql://user:pass@instance0000.db.xeround.com.:1234/app000000")
>>> engine.execute("SELECT USER()").scalar()
>>> exit()

我这样做过几次。然后我检查了我的 Xeround 管理仪表板，它显示了 2 个连接。那是在我了解到:

>>> engine = create_engine("mysql://user:pass@instance0000.db.xeround.com.:1234/app000000")
>>> conn = engine.connect() # dashboard shows 3 connections
>>> conn.close() # dashboard still shows 3 connections
>>> exit() # after exiting, dashboard shows 2 connections

我如何强制 Xeround 关闭剩余的 2 个连接(例如原谅我忘记关闭它们)？

Answer 1

How do I force Xeround to close the remaining 2 connections (e.g. to forgive me for forgetting to close them)?

如果您重新启动 mysql 服务，一切都会再次正常运行，因为您的连接没有正确关闭。在这种情况下，您需要使用 A Connection Pool