MySQL Forums
Forum List  »  Performance

Re: To get details of memory and CPU resource usage with performance schema
Posted by: Peter Brawley
Date: August 01, 2018 08:39AM

> identifying which queries are in need of CPU & memory resource

Assuming you are using innodb, innodb_buffer_pool_size should be about 75% of RAM available to MySQL.

Turn on the slow query log, on the queries it reports run Explain, using those results optimise those queries esp. by providing indexing sufficient to minimise time spent and memory use.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: To get details of memory and CPU resource usage with performance schema
86
August 01, 2018 08:39AM


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.