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
2496
Peter Bukaowski
June 15, 2017 01:40AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
915
Peter Brawley
June 15, 2017 11:15AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
1037
Peter Brawley
June 15, 2017 12:52PM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
3108
Peter Bukaowski
June 16, 2017 01:03AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
925
Peter Brawley
June 19, 2017 02:12AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
825
Peter Bukaowski
June 19, 2017 06:03AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
771
Peter Brawley
June 19, 2017 10:25AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
819
Peter Bukaowski
June 20, 2017 03:52AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
962
Peter Brawley
June 20, 2017 09:07AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
883
Øystein Grøvlen
June 22, 2017 01:59AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
716
Peter Bukaowski
July 31, 2017 04:09AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
708
Øystein Grøvlen
August 22, 2017 05:48AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
748
Peter Bukaowski
August 24, 2017 05:44AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
748
Øystein Grøvlen
August 25, 2017 05:00AM
Re: High memory usage on mysql 5.7.18 running on ubuntu server 16.04
879
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.