----- Original Message ----- From: "Chris Faust" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 27, 2002 10:22 PM Subject: Desperate - failed: Lost connection to MySQL server during query
> The problem is this, everytime the web server starts to work a little > (load via a uptime showing about 6), 1 out of 5 scripts bomb out with > the message of: > > "failed: Lost connection to MySQL server during query" > > As load gets higher then the rate of failure gets higher. I lack the necessary info on your scripts, of course; but you might be looking at it from the wrong angle. I would ere expect a time-out issue with the Apache server (that is, with its spawned children). Try a "netstat -a"; are many http connection in a TIME_WAIT state? The "Timeout" value in httpd.conf also leaps to mind. A CPU load of 6, though not itself excessively high, may be an indication that the Apache server gets hits with many, many requests, forcing many to remain in a TIME_WAIT state for a while -- long enough to cause a potential problem for the MySQL connection, at least. A solid test, I would say, is to try and run your Perl scripts directly, and not via a web-page. I have a nagging suspicion the errors will be gone. - Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
