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 22, 2017 11:28AM

Thanks. MySQL is running MyISAM exclusively. With 32GB RAM, key_buffer_size can safely be up to about 8GB depending on other processes. Yours is just 128 MB, you have 0.4 GB of MyISAM indexes, they'll all fit in RAM if key_buffer_size is greater than that number.

Also need the result of ...

show global status;

You didn't say whether there are performance problems or slow queries.

Options: ReplyQuote


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


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.