Connection to the server was lost

from the Artful MySQL Tips List


This response to a query has four possible causes ...

1 the server crashed

2 net_read_timeout is shorter than the time the query took. If that's so, increasing it will fix 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



Return to the Artful MySQL Tips page