The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

increased memory usage of mysql process

Discussion in 'Workarounds and Optimization' started by madpato, Jul 19, 2013.

  1. madpato

    madpato Active Member

    Joined:
    May 30, 2008
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    6
    Hello

    I have a cpanel server with cloudlinux and I keep seeing this on my process manager:

    It keeps using more and more memory and from time to time i have to kill the process, at first i had open-files-limit in 50000, i doubled it and still this happens (readed this post).
    So after that i went to check the log var/lib/mysql/server.name.err and nothing odd.

    I readed another post claiming that in some cases the tmp of mysql should be changed so i did that as well (because it might fill the tmp partition), so in my.cnf i added: tmpdir=/mysqltmp

    And still no luck, is this normal? Regards.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,738
    Likes Received:
    661
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Are you receiving actual errors with MySQL, or is it only the process itself that concerns you? You may want to consider tuning your MySQL configuration if you haven't already. I have moved this thread over to our "Optimization" forum as you will likely get more user input here. Here is a good thread to start with:

    MySQL server statistics gather tool

    Thank you.
     
  3. madpato

    madpato Active Member

    Joined:
    May 30, 2008
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    6
    Hello its the process that concerns me, can you please explain me what this process do? i have already used that tool and i have tuned my mysql well maybe i have to rerun that script to adjust some parameters.

    Thanks.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,738
    Likes Received:
    661
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You are seeing the standard MySQL process. It's supposed to be running at all times so that MySQL is accessible. It's normal for a process to be allocated RAM on a Linux system. It's only a problem if you are experiencing issues with MySQL failing or degrading the performance of your server.

    Thank you.
     
Loading...

Share This Page