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.
The problem is now resolved, and it was a server configuration issue,
albeit quite a difficult one to spot.
The wait_timeout variable was not being set in the server's my.cnf,
although interactive_timeout was.
SHOW VARIABLES LIKE '%timeout';
shows session variable values, and lists the value of wait_timeout as
30 days, the same as our setting of interactive_timeout.
However, using SHOW GLOBAL VARIABLES revealed what the global setting
for wait_timeout was, and it was this that was being obeyed by the
server.
Thanks for your help, chaps, and I'm sorry for troubling you when it
wasn't actually a perl problem in the end...
Tim
5 messages in com.mysql.lists.perlRe: Odd timeouts talking to MySQL 4.0...