Re: Lost connection to MySQL server during query
> 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.
Subject
Written By
Posted
November 12, 2017 08:21PM
November 12, 2017 08:39PM
November 12, 2017 10:46PM
November 13, 2017 04:52AM
November 13, 2017 12:06PM
November 13, 2017 09:25PM
November 13, 2017 09:59PM
November 13, 2017 10:43PM
November 14, 2017 09:58AM
November 14, 2017 10:49AM
November 14, 2017 11:25AM
November 14, 2017 11:51AM
November 14, 2017 12:13PM
November 14, 2017 12:24PM
November 14, 2017 12:30PM
November 14, 2017 01:11PM
November 14, 2017 01:16PM
November 14, 2017 01:40PM
November 14, 2017 02:11PM
November 14, 2017 02:13PM
November 14, 2017 02:22PM
November 14, 2017 03:50PM
November 14, 2017 04:41PM
November 14, 2017 04:08PM
Re: Lost connection to MySQL server during query
November 14, 2017 05:11PM
November 14, 2017 06:53PM
November 14, 2017 06:56PM
November 14, 2017 06:59PM
November 14, 2017 07:00PM
November 14, 2017 09:47PM
November 19, 2017 06:50AM
November 14, 2017 12:21PM