Only increase max_allowed_packet is ok. On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn