Qt-interest Archive, December 2006
MySQL connection timeouts
Message 1 in thread
Mysql 4.1 server
Mysql 4.1 clients, via Qt3 MySQL plugin driver
My software works well using this setup. However, on the client side if I upgrade
to MySQL 5.0 and rebuild Qt3 to use MySQL 5 everything continues to work like normal
EXCEPT after some period of time ( many hours ) of inactivity the connection closes
and there is no automatic reconnection.
Has anyone else experienced this issue in migrating your MySQL client to 5.0? I
imagine there's some trickery that Qt does when handling the opening of the
connection that must be different between versions.
The applications typically sit idle for many many hours, sometimes days, however the
connections never seems to close when I'm using the MySQL 4.1 based client. I've
read that I can increase the timeout time via the server, which is okay, but I'm
curious if I can't solve this somehow on the client side. I realize this is
somewhat of a MySQL issue, but since I'm using the client through Qt there's not a
lot I can do to specify options when opening the connection.
Any thoughts are appreciated.
Caleb
--
[ signature omitted ]
