MySQL Forums
Forum List  »  Newbie

Re: Lost connection to MySQL server during query
Posted by: Peter Brawley
Date: November 14, 2017 12:24PM

> 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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Lost connection to MySQL server during query
November 14, 2017 12:24PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.