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

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;



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

Options: ReplyQuote


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


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.