MySQL Forums
Forum List  »  Newbie

Re: Lost connection to MySQL server during query
Posted by: Christopher Popplewell
Date: November 14, 2017 12:21PM

I stopped the offending service (php-cgi) by stopping apache. php-cgi had two processes running which was peaking CPU to ~80%.
The query still failed.


mysql> select
-> ifnull(engine,'TOTALS') as storage_engine,
-> round(data/1024/1024,1) as dataMB,
-> round(idx/1024/1024,1) as idxMB,
-> round((data+idx)/1024/1024,1) as totalMB
-> from (
-> select
-> engine,
-> sum(data_length) as data,
-> sum( index_length) as idx
-> from information_schema.tables
-> where engine not in('information_schema','performance_schema')
-> and engine is not null
-> group by engine with rollup
-> ) sums
-> order by storage_engine;

show engine innodb status;

show variables;


ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
mysql> show engine innodb status;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server

mysql>
mysql> show variables;
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server

Options: ReplyQuote


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


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.