On 17 Feb 2004, at 16:32, Jochen Wiedmann wrote:
Tim Cutts wrote:
where we are seeing the same problem (dropped connections after 8
hours):
Most probably you are not observing *dropped* connections but are using
a current version of DBD::mysql, which is not *reconnecting*
automatically,
if the *server* drops a connection after 8 hours. Beginning with 2.9002
you need to enable the mysql_auto_reconnect flag. See the drivers
documentation for details.
Yes, I realise that, but *why* is the server dropping the connection
after 8 hours? Our settings of the wait_timeout and
interactive_timeout should enable connections to live for about a month
(and indeed on MySQL 3 servers, that is the case). I'm slightly scared
of the auto_reconnect because of the issues with lost locks.
Tim
PS. Don't ask why we need connections that live this long... the
programmers insist on it. I, the mere sysadmin, have to live with it.
5 messages in com.mysql.lists.perlRe: Odd timeouts talking to MySQL 4.0...