From: MAS!
Date: January 16 2008 9:06am
Subject: Re: Lost Connection each hour :(
List-Archive: http://lists.mysql.com/mysql/210864
Message-Id: <FB12C450-D147-431D-8867-B57C4A44C02C@gmail.com>
MIME-Version: 1.0 (Apple Message framework v753)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-Transfer-Encoding: 7bit

> can you post values of wait_timeout and interactive_timeout  
> variables. You can get them from SHOW VARIABLES output. If they are  
> set to 3600 (1 hour in secs), set them to something bigger like one  
> week and then you will see if it helps or not. You can read more about

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 28800 |
| net_read_timeout         | 30    |
| net_write_timeout        | 60    |
| slave_net_timeout        | 3600  |
| table_lock_wait_timeout  | 50    |
| wait_timeout             | 28800 |
+--------------------------+-------+

:( may be I have to increase the net_% variables?