MySQL Forums
Forum List  »  Newbie

Re: MySQL is eating all the CPU 100% - Guide me to fix this please
Posted by: Peter Brawley
Date: October 16, 2017 10:23AM

Not nearly enough info.

There are > 5 processors? How much RAM? MySQL version? OS? How busy is it? Let's see the results of ...

show variables;
show engine innodb status;

and 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;



Edited 1 time(s). Last edit at 10/16/2017 10:26AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL is eating all the CPU 100% - Guide me to fix this please
October 16, 2017 10:23AM
November 07, 2017 09:51AM


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.