Re: Mysql high memory usage on centos 7 (migrating from centos 5)

[Peter Brawley]

Unfortunately uptime since last flush is too short for reliable values. Please wait till MySQL has been running at least a couple of hours in a representative period, then run show global status again. Also please post the result of this query ...

select engine,data,indexes,total
from (
  select 
    ifnull(engine,'TOTALS') as engine, 
    concat(data,' GB') as data, 
    concat(indexes,' GB') as indexes, 
    concat(tot,' GB') as total,
    if(engine is null,-1,tot) as ord
  from (
    select   
      engine,  
      round( sum(data_length)/1024/1024/1024, 1 ) as data,  
      round( sum(index_length)/1024/1024/1024, 1 ) as indexes,  
      round( sum(data_length+index_length)/1024/1024/1024, 1 ) as tot
    from information_schema.tables
    where engine is not null and engine not in('information_schema','performance_schema')
    group by engine with rollup
  ) sums
) list
order by list.ord desc;