Re: bugs Digest 29 Sep 2004 18:58:38 -0000 Issue 636

> -----------------------------------------------------------
> From: Ed Korthof <[email protected]>
> Subject: intermittent 'Lost connection to MySQL server' errors w/ DBI
 . . .
> Lost connection to MySQL server during query at ./mysql_running line 33.
 . . .
> Our my.cnf looks like this:
> 
>     [mysqld]
>     set-variable=max_allowed_packet=10485760
>     set-variable=max_connections=355

1. The my.cnf is the same on all boxes? What does "show variables like
'%t_timeout%'" give on at least the box that's broken and one that
isn't? We're looking specifically for "wait_timeout" and
"connect_timeout".

2. Any firewall rules on either box? Find out what, if any, firewall
software you have running. ipfw? iptables? Check the rules. Make sure
nothing is closing "inactive" connections or otherwise closing
connections.

3. Assuming the above turn up no clues, ask your Unix admin (if it isn't
you) to look at the network layer. Packet loss? Transmit errors? All the
usual suspects.

--
timeless



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]