Remote MySQL connection fails after 5-6 hours

HI All,

Need help desperatly... I am running MySQL 3.23.52-3 under Linux RH 8.0 with Perl DBD 2.1017-3 and Perl DBI 1.30-1. The queries are made from Perl CGI scripts running under Apache with PerlRun, to a second Linux machine on the same LAN, on which MySQL is running. At first all goes well, but after 5-6 hours (60,000-100,000 queries) the MySQL Linux server freezes completely. The Apache server starts spitting out "no route to host". Any suggestion? I have traced the DBI interface and everything seems to work fine. When both Apache and MySQL server are on same machine, all works perfectly well...

Thanks for the help

Luc


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org