Someone or something using too much resources?

Portal Home > Knowledgebase > Articles Database > Someone or something using too much resources?

Posted by otamendi, 10-05-2011, 09:29 PM
Hi, lately our brand new quad core server has been having a lot of cpu load, we suspect someone is using a chat/mysql script how can we know wich user is or script? our server load is: Server load 3.04 (4 CPUs) using WHM process manager we see one process using 53.8 cpu or more the owner is mysql with the command: /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.dnsanonimos.com.pid --skip-external-locking This is new on our server just happen today, how can we tell what is causing the high cpu load? thanks.
Posted by almanox, 10-06-2011, 03:18 AM
Use (install) mytop to see which user's queries take most of mysql server. You may also enable slow query log in my.cnf to see if there are any queries that can be further optimized.
Posted by otamendi, 10-06-2011, 11:11 AM
Hi thanks for the answer i am trying to install mytop with these instructions http://www.eth0.us/mytop but it gives me a file not found error when trying to download DBI from http://search.cpan.org/CPAN/authors/...BI-1.48.tar.gz So i tried with these tutorial http://www.sohailriaz.com/how-to-ins...one-for-mysql/ and it shows these errors: How can i install MyTop without errors ? Am running latest stable CENTOS release with CPANEL & WHM installed on the server. Thanks.
Posted by otamendi, 10-06-2011, 11:47 AM
Thanks i did it now and i found the culprit (php chat script as i suspected).
Posted by hb9aj4fn, 10-06-2011, 12:57 PM
Would you please share wich php chat script it was? Like LiveZilla or any of the others?
Posted by otamendi, 10-06-2011, 01:01 PM
It was on my WHM manager as cPanel Chat 1 phpMyChat (0.15.0) as an cPAddons and i remove it from the server in that same part. I succesfully install mytop using this tutorial: http://www.mixinformatico.com/2010/0...nstalar-mytop/