Re: Lost connection to MySQL server during query

[Peter Brawley]

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