MySQL - high memory usage

**shizzle** · 04-18-2005 04:42 PM

hi,
i have the followning problem:

if i chceck Main >> Server Status >> CPU/Memory/MySQL Usage i get a 113% usage of the memory on this process:

mysql 3.72 113.07 0.0
Top Process %CPU 6.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/srv1.compacthost.com.pid --skip-locking --port3306 --socket/var/lib/mysql/mysql.sock
Top Process %CPU 4.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/srv1.compacthost.com.pid --skip-locking --port3306 --socket/var/lib/mysql/mysql.sock
Top Process %CPU 2.2 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/srv1.compacthost.com.pid --skip-locking --port3306 --socket/var/lib/mysql/mysql.sock

the CPU usage is normal, it has to do something with sessions, if i delete the session data in the tmp folder, the memory usage goes down... someone told me that this helps.. yep it helps but in 3-4 days is the mem usage again high.. perhaps is the MySQL configuration wrong?!

can somebody help me?

thanks

**anup123** · 04-18-2005 05:04 PM

Oh i checked mine and found it to be that high almost in all daily reports. This spiking has started from 5th March 2006 and nothing much has been done on server except for running ./upcp

Not really sure if anything has changed after 5th March 2005 from cPanel's end. I am on CURRENT Tree

Anybody else seeing this??

TIA
Anup

**linuxserverguy** · 05-09-2005 11:04 AM

yes most of my servers with current cpanel builds are showing HIGH mysql ram usage too. this is really bugging me ... cpanel pro's can you answer is this bug or some nuts and bolts need to tighten?

**Daniel Artes** · 05-14-2005 07:52 PM

same problem over here..

**t9clkclnr** · 05-14-2005 08:08 PM

yes i experience it on my 2 servers as well.

**t9clkclnr** · 05-26-2005 11:50 AM

any response to this. have done some searches with no positive result.

**Website Rob** · 05-26-2005 01:17 PM

Had the same problem on a Server also using Current and switching to Release solved the problem.

**t9clkclnr** · 05-26-2005 09:09 PM

my server is set to release and from the last 2 updates I've run over the past month it's been the same problem.

**MK Hosting** · 06-30-2006 06:59 PM

Any updates on this? I am having the same problem.

**kship** · 07-13-2006 04:24 PM

same here as well

**kship** · 07-14-2006 04:49 AM

remove the advanced guestbook from the server completely and remove any instances of it installed. I did this and the server has been purring nicely since.