4 messages in com.mysql.lists.mysqlRe: Lost connection to MySQL server d...
FromSent OnAttachments
Amir Shay25 May 2005 14:36 
Gleb Paharenko25 May 2005 15:22 
Amir Shay26 May 2005 07:39 
Gleb Paharenko30 May 2005 06:11 
Subject:Re: Lost connection to MySQL server during query problem
From:Gleb Paharenko (gleb@ensita.net)
Date:05/25/2005 03:22:55 PM
List:com.mysql.lists.mysql

Hello.

Does SHOW STATUS executed from JDBC client return increased values of this parameters? Could your server die during queries from JDBC (check the error
log)? Sometimes you should increase interactive_timeout as well. A lot of
variables usually could be changed using SET statement. See: http://dev.mysql.com/doc/mysql/en/system-variables.html

Sometimes when querying mySQL 4.1.11 on Linux machine I get the error "Lost connection to MySQL server during query". Here are the symptoms

1. When running the query from the server it returns OK 2. When running the query from another machine using the mySQL query browser it returns OK 3. When running the query from another machine from Java using mySQL JDBC it fails with " Lost connection to..." 4. When running the query from another machine using software like EMS it fails with " Lost connection to..." 5. The error is always after 4.7 seconds and only in "heavy" queries (not only SELECT, even DELETES )

The problem is probably not in the communication parameters, like max_allowed_packet or connection_timeout on the server because I increased then ....

Does anyone know how can I control those parameters from JDBC?

"Amir Shay" <am@pineapp.com> wrote: