increased memory usage of mysql process

[madpato]

Hello

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

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.name.err --open-files-limit=100000 --pid-file=/var/lib/mysql/server.name.pid

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.

 

[cPanelMichael]

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.

 

[madpato]

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.

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.

 

[cPanelMichael]

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.