Hi,
Yes the server dies during the queries from JDBC.
Regarding the client parameters, what if the client doesn't have mySQL
installed?
Amir
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" <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
