PySQLPool is a MySQL Connection Pooling for Python 2.4+ built on-top of the famous MySQLdb Python library. My goal of PySQLPool is to provide a simple yet robust pooling library for use in and Python application. Wether it be a simple script to a complex website built on WSGI. PySQLPool can handle it. Even this very website is built upon it, and a few others that you may interact with on a daily bases.
GNU Lesser General Public License v3.0
57
stars
21
forks
source link
Keeping connections alive for long running queries. #10
EDIT: I'm currently working on some code that uses MySQLdb and I ran into an issue with a connection closing during processing, but the query continued on the database server.
For another database technology suffering from the same issue, we just defined a keep alive value on the Unix socket. However, I didn't see anything with MySQLdb/_mysql that would help.
Is there a way to use PySQLPool to do a keep alive on MySQLdb connections?
UPDATE: I verified on the database server that the wait/interactive timeouts are already set large (28800). I just need to confirm where and where the disconnect is happening.
EDIT: I'm currently working on some code that uses MySQLdb and I ran into an issue with a connection closing during processing, but the query continued on the database server.
For another database technology suffering from the same issue, we just defined a keep alive value on the Unix socket. However, I didn't see anything with MySQLdb/_mysql that would help.
Is there a way to use PySQLPool to do a keep alive on MySQLdb connections?
UPDATE: I verified on the database server that the wait/interactive timeouts are already set large (28800). I just need to confirm where and where the disconnect is happening.