Keeping connections alive for long running queries.

[raniemi]

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.