***BOGO*** Re: Lost connection

["Moon's Father" <yueliangdao0608@xxxxxxxxx>]

Only increase max_allowed_packet is ok.

On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <warren@xxxxxxxxxxx> wrote:

> Mad Unix wrote:
>
>>
>> During the update of the MySQL DB (delete/insert), I keep getting the
>> following message
>> Lost connection to MySQL server during query...
>>
>
> By default, the MySQL server drops a connection after 8 hours of receiving
> no queries on that connection.  This can happen in an application that keeps
> its connection open constantly, and people don't use it overnight or over a
> weekend.
>
> You can either increase the timeout in my.cnf, or you can ping the
> connection occasionally with mysql_ping().  Or, you can add code to your
> applications to detect this, and reestablish the connection and retry the
> command.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=yueliangdao0608@xxxxxxxxx
>
>


-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn