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

> have queries use Heap tmp tables

https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html

> Is the cache going to happen on disk or memory?

I suggested you disable the cache (deprecated in 5.7, removed in 8.0), grow the key buffer to hold all myisam indexes plus some headroom.

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:50PM


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.