Re: High memory usage on mysql 5.6.36-log on linux server

[Peter Brawley]

Not a very busy or huge system but some settings are high enough to require swapping, not good. No reboots or settings changes in 9 months, wow. Let's see the result of ...

show variables;

and let's see the result of ...

select 
  engine,
  concat(round(sum(table_rows)/1000000,2),'m') rows, 
  concat(round(sum(data_length)/(1024*1024*1024),2),'g') data, 
  concat(round(sum(index_length)/(1024*1024*1024),2),'g') idx, 
  concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'g') 
  total_size, 
  round(sum(index_length)/sum(data_length),2) idxfrac 
from information_schema.tables 
group by engine;