MySQL Forums
Forum List  »  Newbie

Re: Lost connection to MySQL server during query
Posted by: Peter Brawley
Date: November 13, 2017 09:59PM

> In the query log, you would see tens of thousands of queries completing and kicking off at 2030 in this small sample.

Busy system. This database may be under-resourced. Assuming it's a dedicated server, how much RAM is available to MySQL, and could we please see the results of ...

  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 (
    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;

Edited 1 time(s). Last edit at 11/14/2017 09:55AM by Peter Brawley.

Options: ReplyQuote

Written By
Re: Lost connection to MySQL server during query
November 13, 2017 09:59PM

Sorry, you can't reply to this topic. It has been closed.

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.