MySQL Forums
Forum List  »  Newbie

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

> Where would I look for the log entry

The MySQL error log is usually named <machinename>.err, it's in <datadir>.

> I increased net_read_timeout to 120 from 30.
> Still...
> ERROR 2013 (HY000): Lost connection to MySQL server during query

There's something terribly wrong with a system that crashes with that simple diagnostic query.

It may not've been the best decision to trust your company and data to an outfit that calls itself "GoDaddy".

Two more possibilities to try for the cause of the error on that query. Presumably the same problem is blocking the others.

> Per second averages calculated from the last 12 seconds

So MySQL had just restarted. Did you restart it, or did it do so by itself?

At least you got one cmd to run. Unfortunately the server had been running for just twelve seconds, so it's not informative.

We still need ...

show variables;

Also ...

show status;

When you get MySQL running again, before trying the above, try running even simpler queries, starting with ...

select 1;

and working forward while watch the mysql .err file for errors.



Edited 2 time(s). Last edit at 11/14/2017 05:18PM by Peter Brawley.

Options: ReplyQuote


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


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.