Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

increased memory usage of mysql process

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

  1. madpato

    madpato Well-Known Member

    Joined:
    May 30, 2008
    Messages:
    50
    Likes Received:
    1
    Trophy Points:
    58
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,952
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. madpato

    madpato Well-Known Member

    Joined:
    May 30, 2008
    Messages:
    50
    Likes Received:
    1
    Trophy Points:
    58
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,952
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice