MySQL Forums
Forum List  »  Newbie

Re: MySQL is eating all the CPU 100% - Guide me to fix this please
Posted by: Mahesh Kumar
Date: October 24, 2017 11:45PM

have queries use Heap tmp tables. - How do i set it. I am not able to find it. Please advice

key buffer to cache index - you advised me to make it big enough to hold all the indexed.

Is the cache going to happen on disk or memory?
I asked free persons. They didn't give exact answer.
There server is not using any RAM. I assumed the cache is going to be in RAM and gave key_buffer_size = 6442450944

Can i check the performance with this value. One of the guy told it is not good idea setting to 6442450944. Confusing.

I have more than 28GB RAM free on the server.

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 24, 2017 11:45PM


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.