Warning: The system load average is 120.5

TARIMEHR

TARIMEHR

Verified User
Joined
Nov 19, 2012
Messages
22
Location
ایالت متحده مازندران
Hi
one of my site that hosted on vps(directadmin) notifying me that the load average on my system is 120.5.

One Minute - 110.79
Five Minutes - 120.5
Fifteen Minutes - 74.88

Code: 
top - 15:21:32 up 3 days, 22:12,  1 user,  load average: 103.60, 118.85, 74.59
Tasks: 269 total,   2 running, 264 sleeping,   0 stopped,   3 zombie
Cpu(s):  1.7%us,  0.4%sy,  0.0%ni, 97.5%id,  0.4%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   3924372k total,  1455400k used,  2468972k free,     9320k buffers
Swap:  4063224k total,  1000080k used,  3063144k free,    44232k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
12096 mysql     20   0  381m  50m 2144 D  4.0  1.3   0:00.02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s5.henterz.com.err --pid-file=/var/lib/mysql/s5.henterz.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306                                                                                                                                                                                                                                                                               
12122 mysql     20   0  381m  50m 2148 D  4.0  1.3   0:00.02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s5.henterz.com.err --pid-file=/var/lib/mysql/s5.henterz.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306                                                                                                                                                                                                                                                                               
12130 mysql     20   0  380m  49m 2148 D  4.0  1.3   0:00.02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s5.henterz.com.err --pid-file=/var/lib/mysql/s5.henterz.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306                                                                                                                                                                                                                                                                               
 354 root      20   0     0    0    0 D  2.0  0.0   0:12.74 [jbd2/dm-0-8]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
11028 sabapato  20   0  169m  14m 2196 D  2.0  0.4   0:00.46 /usr/sbin/httpd -k start -DSSL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
11120 sabapato  20   0  184m  20m 2416 D  2.0  0.5   0:00.44 /usr/sbin/httpd -k start -DSSL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
11184 apache    20   0     0    0    0 Z  2.0  0.0   0:00.20 [httpd] <defunct>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
11383 apache    20   0  152m  15m 3156 S  2.0  0.4   0:00.25 /usr/sbin/httpd -k start -DSSL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
11456 root      20   0 54988 1796 1208 S  2.0  0.0   0:00.09 /usr/local/directadmin/dataskq                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
   1 root      20   0 19364   56    4 S  0.0  0.0   0:00.96 /sbin/init                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
   2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 [kthreadd]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
   3 root      RT   0     0    0    0 S  0.0  0.0   0:00.15 [migration/0]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   4 root      20   0     0    0    0 S  0.0  0.0   0:00.62 [ksoftirqd/0]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [migration/0]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   6 root      RT   0     0    0    0 S  0.0  0.0   0:00.29 [watchdog/0]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
   7 root      RT   0     0    0    0 S  0.0  0.0   0:00.12 [migration/1]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [migration/1]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   9 root      20   0     0    0    0 S  0.0  0.0   0:00.31 [ksoftirqd/1]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
  10 root      RT   0     0    0    0 S  0.0  0.0   0:00.24 [watchdog/1]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
  11 root      RT   0     0    0    0 S  0.0  0.0   0:00.21 [migration/2]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
  12 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 [migration/2]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
  13 root      20   0     0    0    0 S  0.0  0.0   0:00.11 [ksoftirqd/2]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
  14 root      RT   0     0    0    0 S  0.0  0.0   0:00.23 [watchdog/2]

Apache: 2.4.9
mod_ruid2: 0.9.8
Dovecot: 2.2.12
AWstats: no
Exim: 4.82
exim.conf update: yes
SpamAssassin: no
ClamAV: 0.98.3
MySQL: no
MySQL backup: yes
MySQL backup directory: /usr/local/directadmin/custombuild/mysql_backups
PHP (default): 5.5 as mod_php
phpMyAdmin: 4.1.14-all-languages
ProFTPD: no
Pure-FTPd: 1.0.36
RoundCube webmail: 1.0.0
Replace "php.ini" with './build all' and './build php_ini': no
Auto updates/notifications: no
Run "clean" every time: yes
Run "clean_old_webapps" every time: yes
Run "clean_old_tarballs" every time: yes
Show texts in bold: yes
SquirrelMail: 1.4.22-20140402_0200
Zend Guard Loader: no
ionCube loader: 4.6.1
Suhosin: no
Click to expand...


System Information

Processor Name Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 3399.997
Processor Name Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 3399.997
Processor Name Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 3399.997
Processor Name Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 3399.997
Total Memory 3924372 kB
Click to expand...

MySQL 5.5.31

my.cnf


# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 200M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout




local-infile=0
Click to expand...

Profile of an existing server configuration mentioned
What can I do to solve the overload problem?

Thanks.
 
Both are not just for IDENTIFY, but for ANALYZE...

Those two things give you the ability to check the url caled and the query done to be able to check them and check where is a possible problem

Also, check mysqltuner script

Regards
 
and the trouble was????
was it mysql not having enough memory allocated to work efficiently?
was it a WP runaway plugin? (many of them are poorly written and do case troubles)
of course assuming was the WP site as the other wasnt being used (or was it?)
 
You must log in or register to reply here.
Back
Top