1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

High mysql memory use..

Discussion in 'Server Configuration and Hosting' started by Claudio, Dec 18, 2011.

  1. Claudio

    Claudio Well-Known Member

    I just want to ask why the mysql process is using so much memory (5,4):

    Any suggestion?
  2. Walter

    Walter Well-Known Member

    Why do you consider 5% high? This is very reasonable.
    What values do you have in your Mysql ini file? Mysql reserves memory according to your ini file.
  3. estranged

    estranged Well-Known Member

    This is our memory usage and even I don't consider it high :)
  4. Kacee

    Kacee Member

    it makes no sense to tell high memory usage just from the percentage, how much memory do you got? how large is your InnoDB index and data space?
  5. ChemicalKicks

    ChemicalKicks Well-Known Member

    heh I wouldn't even know how to check mysql usage of memory.
  6. Claudio

    Claudio Well-Known Member

    I´m using default mysql index (no InnoDB), my server has 4gb of memory...
    The screenshot was taken when the load average was in 2,3, so I´m worried about that
  7. Walter

    Walter Well-Known Member

    Higher loads can have many reasons.

    Normally I would suggest taking a look at the output of top or vmstat during high loads, but when you don't feel comfortable with your server I suggest get someone who can manage your server.
    Slavik likes this.
  8. digitalpoint

    digitalpoint Well-Known Member

    That's actually pretty low for MySQL. A database server can never really have too much memory... The more of your database it can store in memory, the faster it's going to be (especially indexes).

Share This Page