MySQL Forums
Forum List  »  Performance

Re: MyTOP - Key Efficiency 50.0% - How to improve it?
Posted by: Peter Brawley
Date: January 20, 2018 01:22AM

Need data that relates demand & resources. MySQL version? Mostly OLTP or OLAP systems? How much RAM is available to MySQL? Post the result 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 variables;

show global status;

Options: ReplyQuote




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.