MySQL Forums
Forum List  »  Performance

Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
Posted by: Peter Brawley
Date: June 15, 2017 11:15AM

First priority is to get rid of swapping, which absolutely kills performance.

First impression is that you need more RAM. An initial assessment can be got from running the "cheatsheet" described at https://www.artfulsoftware.com/infotree/mysqltips.php.

Are you running the slow query log? That will identify inefficient queries.

Options: ReplyQuote




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.