MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
High memory usage on mysql 5.7.18 running on ubuntu server 16.04
2411
Peter Bukaowski
June 15, 2017 01:40AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
892
Peter Brawley
June 15, 2017 11:15AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
1012
Peter Brawley
June 15, 2017 12:52PM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
3050
Peter Bukaowski
June 16, 2017 01:03AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
904
Peter Brawley
June 19, 2017 02:12AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
793
Peter Bukaowski
June 19, 2017 06:03AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
739
Peter Brawley
June 19, 2017 10:25AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
786
Peter Bukaowski
June 20, 2017 03:52AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
921
Peter Brawley
June 20, 2017 09:07AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
861
Øystein Grøvlen
June 22, 2017 01:59AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
692
Peter Bukaowski
July 31, 2017 04:09AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
686
Øystein Grøvlen
August 22, 2017 05:48AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
720
Peter Bukaowski
August 24, 2017 05:44AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
725
Øystein Grøvlen
August 25, 2017 05:00AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
846
Peter Bukaowski
September 28, 2017 02:15AM


Sorry, you can't reply to this topic. It has been closed.

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.