Re: Lost connection to MySQL server during query

[Peter Brawley]

> Lost connection to mysql server

Mainly that has four possible causes ...

1 the server crashed, in which case the mysql error log will show the error

2 net_read_timeout is shorter than the time the query took. If that's so, increasing it wil lfix the problem

3 connect_timeout is shorter than the time taken to connect. If that's so, show global status like 'Aborted_connects' will increment by 1 on each connection attempt, and increasing connect_timeout will fix the problem

4 max_packet_size is smaller than blobs asked for by the query. If so, you should see a packet-too-large error, and increasing packet size should fix the problem

Please advise which you can confirm.