#1 (permalink)  
Old 07-06-2009, 02:47 PM
Registered User
 
Join Date: Feb 2009
Posts: 7
rene123 is on a distinguished road
Something is eating memory

Server Load 2.31 (2 cpus)
Memory Used 83.1 %
Swap Used 51.81 %
Disk /dev/sda1 (/) 20 %

2gb memory, dual-core. Something is taking all the memory, and I don't know how to find the leak. Any leads? It comes and goes, so it's not always overloaded.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 07-06-2009, 03:06 PM
Registered User
 
Join Date: Mar 2009
Posts: 65
robbie_troster is on a distinguished road
Best thing to do is use the 'top' command in SSH and then press c to see the command line.

Look at the VIRT section where the ram usage is shown.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 07-06-2009, 03:08 PM
Registered User
 
Join Date: Feb 2009
Posts: 7
rene123 is on a distinguished road
Ok, something at least...
19486 mysql 15 0 141m 24m 3692 S 50.2 1.2 10750:36 mysqld
1461 nobody 15 0 12676 3112 1528 S 0.7 0.2 0:00.07 httpd
2824 nobody 15 0 12944 3200 1536 S 0.7 0.2 0:00.16 httpd
2868 nobody 16 0 12804 3168 1532 S 0.7 0.2 0:00.32 httpd
6137 kim 16 0 17456 6488 4448 S 0.7 0.3 0:00.02 php5
2158 nobody 16 0 12676 3072 1528 S 0.3 0.1 0:00.06 httpd
2986 nobody 16 0 12676 2920 1532 S 0.3 0.1 0:00.06 httpd
2990 nobody 15 0 12540 2840 1520 S 0.3 0.1 0:00.03 httpd
5132 nobody 15 0 12676 2948 1520 S 0.3 0.1 0:00.01 httpd
5177 nobody 15 0 12540 2844 1520 S 0.3 0.1 0:00.03 httpd
5642 nobody 16 0 12540 2828 1528 S 0.3 0.1 0:00.01 http

Todays CPU Usage
Top Process %CPU 47.6 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/cpanel.example.net.pid --skip-external-locking
Top Process %CPU 47.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/cpanel.example.net.pid --skip-external-locking
Top Process %CPU 47.4 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/cpanel.example.net.pid --skip-external-locking

Last edited by rene123; 07-06-2009 at 03:15 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 07-06-2009, 03:32 PM
Registered User
 
Join Date: Mar 2009
Posts: 65
robbie_troster is on a distinguished road
Quote:
Originally Posted by rene123 View Post
Ok, something at least...
19486 mysql 15 0 141m 24m 3692 S 50.2 1.2 10750:36 mysqld
1461 nobody 15 0 12676 3112 1528 S 0.7 0.2 0:00.07 httpd
2824 nobody 15 0 12944 3200 1536 S 0.7 0.2 0:00.16 httpd
2868 nobody 16 0 12804 3168 1532 S 0.7 0.2 0:00.32 httpd
6137 kim 16 0 17456 6488 4448 S 0.7 0.3 0:00.02 php5
2158 nobody 16 0 12676 3072 1528 S 0.3 0.1 0:00.06 httpd
2986 nobody 16 0 12676 2920 1532 S 0.3 0.1 0:00.06 httpd
2990 nobody 15 0 12540 2840 1520 S 0.3 0.1 0:00.03 httpd
5132 nobody 15 0 12676 2948 1520 S 0.3 0.1 0:00.01 httpd
5177 nobody 15 0 12540 2844 1520 S 0.3 0.1 0:00.03 httpd
5642 nobody 16 0 12540 2828 1528 S 0.3 0.1 0:00.01 http

Todays CPU Usage
Top Process %CPU 47.6 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/cpanel.example.net.pid --skip-external-locking
Top Process %CPU 47.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/cpanel.example.net.pid --skip-external-locking
Top Process %CPU 47.4 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/cpanel.example.net.pid --skip-external-locking

There doesn't seem to be much of a problem there....

Kim looks a bit powerful however... and something is using mysql quite a lot. Mine only uses abotu 50m yours is using 141m
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 07-06-2009, 03:52 PM
Registered User
 
Join Date: Feb 2009
Posts: 7
rene123 is on a distinguished road
Kim has a big site, around 3-5k visitors a day. But it should not be a problem...

Is there any log file for mysql I can dig into?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 07-06-2009, 06:02 PM
Registered User
 
Join Date: Mar 2009
Posts: 65
robbie_troster is on a distinguished road
/var/lib/mysql/$(hostname).err

This path could vary, but is generally located in /var/lib/mysql. Could also be located at /var/log/mysqld.log
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 07-07-2009, 02:40 AM
Registered User
 
Join Date: Feb 2009
Posts: 7
rene123 is on a distinguished road
I have Centos so I can't find any of these files...

Checked the apache log but the seems to nothing strange there.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 07-07-2009, 01:17 PM
Registered User
 
Join Date: Feb 2009
Posts: 7
rene123 is on a distinguished road
Ok, found something in "Show Current CPU Usage". It's for the big sites account, and is taking 60% of all resources as it seems:

/usr/local/cpanel/3rdparty/bin/analog +CIMAGEDIR /images/ +CDOMAINSFILE /usr/local/cpanel/3rdparty/share/analog/lang/usdom.tab +CCHARTDIR ./ +CALLCHART ON +CLANGFILE /usr/local/cpanel/3rdparty/share/analog/lang/us.lng +COUTFILE /home/kim/tmp/analog/example.kim.example.net/7.html +CLOCALCHARTDIR /home/kim/tmp/analog/example.kim.example.net/ +CCACHEOUTFILE /home/kim/tmp/analog/example.kim.example.net/cache.out +CCACHEFILE /home/kim/tmp/analog/example.kim.example.net/cache +CVHOST ON +COSREP ON +CBROWSER ON +CFULLBROWSER ON +CREDIRREF ON +CREFSITE ON +CFAILREF ON +CLOGFORMAT COMBINED +CHOSTNAME example.kim.example.net +CHOSTURL http://example.kim.example.net/ /usr/local/apache/domlogs/example.kim.example.net

Killed this process and everything went back to normal. So this process is the problem. Now the question is how to stop it from happening again. Tried to disable it under "Statistics Software Configuration", but it seems to be running anyway.

Is it enough to deselect "Enabled by Default" and "Active" on all Statistic Softwares under "Statistics Software Configuration" to disable all Statistic?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 07-10-2009, 12:26 PM
cPanelDavidG's Avatar
cPanel Technical Sales
 
Join Date: Nov 2006
Location: Houston, TX
Posts: 7,995
cPanelDavidG is on a distinguished road
Quote:
Originally Posted by rene123 View Post
Ok, found something in "Show Current CPU Usage". It's for the big sites account, and is taking 60% of all resources as it seems:

/usr/local/cpanel/3rdparty/bin/analog +CIMAGEDIR /images/ +CDOMAINSFILE /usr/local/cpanel/3rdparty/share/analog/lang/usdom.tab +CCHARTDIR ./ +CALLCHART ON +CLANGFILE /usr/local/cpanel/3rdparty/share/analog/lang/us.lng +COUTFILE /home/kim/tmp/analog/example.kim.example.net/7.html +CLOCALCHARTDIR /home/kim/tmp/analog/example.kim.example.net/ +CCACHEOUTFILE /home/kim/tmp/analog/example.kim.example.net/cache.out +CCACHEFILE /home/kim/tmp/analog/example.kim.example.net/cache +CVHOST ON +COSREP ON +CBROWSER ON +CFULLBROWSER ON +CREDIRREF ON +CREFSITE ON +CFAILREF ON +CLOGFORMAT COMBINED +CHOSTNAME example.kim.example.net +CHOSTURL http://example.kim.example.net/ /usr/local/apache/domlogs/example.kim.example.net

Killed this process and everything went back to normal. So this process is the problem. Now the question is how to stop it from happening again. Tried to disable it under "Statistics Software Configuration", but it seems to be running anyway.

Is it enough to deselect "Enabled by Default" and "Active" on all Statistic Softwares under "Statistics Software Configuration" to disable all Statistic?
That should be sufficient to disable stats generation, but any remaining stats processes may still be running to conclude whatever they were working on.
__________________
Want our technical analysts to login to your server to assist you? You can contact our technical analysts at: http://tickets.cPanel.net/submit
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 07-10-2009, 06:23 PM
Registered User
 
Join Date: Mar 2009
Posts: 65
robbie_troster is on a distinguished road
Analog stats should not be using anywhere near that amount of resources. Normally about 0.1%CPU.

Try disabling the analog, update the cPanel, re-enable it, and see what happens.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apache childs eating too much memory fasdush cPanel and WHM Discussions 1 11-08-2007 12:57 AM
Apache eating up all memory carock cPanel and WHM Discussions 4 04-04-2007 04:59 AM
MySQL eating memory... server overload dazmanultra cPanel and WHM Discussions 1 08-23-2005 10:37 AM
spamd eating memory and cpu, load averages > 2 heath cPanel and WHM Discussions 15 08-15-2005 10:23 AM
15-25+ of one process...eating memory.. Devil Inside cPanel and WHM Discussions 1 03-22-2004 09:46 PM


All times are GMT -5. The time now is 04:36 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© cPanel Inc