Subject: Warning: The system load average

[groomy]

Hi,
I receive an error message about a customer, always the same.
How do you know where does the worries and what is the worry?
Thank you for your help.

This is an automated message notifying you that the 5 minute load average on your system is 17.74.
This has exceeded the 10 threshold.

One Minute - 50.63
Five Minutes - 17.74
Fifteen Minutes - 7.17

top - 19:42:02 up 37 days, 8:24, 0 users, load average: 50.63, 17.74, 7.17
Tasks: 370 total, 27 running, 336 sleeping, 0 stopped, 7 zombie
Cpu(s): 2.7%us, 1.6%sy, 0.1%ni, 95.3%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16327796k total, 12724156k used, 3603640k free, 780464k buffers
Swap: 1051064k total, 29908k used, 1021156k free, 8432348k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5267 mysql 20 0 374m 145m 5992 S 243.6 0.9 3825:19 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/ns3002026.ovh.net.err --pid-file=/var/lib/mysql/ns3002026.ovh.net.pid
13852 fernanda 20 0 0 0 0 Z 5.2 0.0 0:00.38 [php-cgi] <defunct>
14116 fernanda 20 0 134m 11m 5184 R 5.2 0.1 0:00.10 /usr/local/php5/bin/php-cgi

 

[nobaloney]

I'm not sure what you mean by customer. The fact that you see two lines for user fernanda qt the top of your top output doesn't mean this user is causing the problem. The first one (pid # 13852) most certainly isn't, since it's defunct; it's not even running; it's just in the process list until the OS cleans it out. The first pid line in your output would give me the impression the problem may be with MySQL, but only because it's at the top of your list and is using the most CPU time.

Start off by restarting MySQL, and see if the server load goes down; it might simply be a stuck query. Make sure your my.conf file is setup to log slow queries, and check your mysql error and slow-query logs.

Jeff

 

[groomy]

thanks, i look now...