Tema: Load average
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 22/03/2012, 14:27
malalengua
 
Fecha de Ingreso: octubre-2003
Mensajes: 153
Antigüedad: 21 años, 2 meses
Puntos: 5
Load average

Hola, últimamente estoy observando que en hora punta, el load average se me dispara a 30 y 60. Os pongo una captura que he hecho del top y a continuación la configuración del my.cnf y del http.conf. APACHE está en prefork

top - 21:15:33 up 144 days, 8:43, 1 user, load average: 36.14, 38.20, 27.27
Mem: 4035300k total, 3035804k used, 999496k free, 14820k buffers
Swap: 6088624k total, 2844908k used, 3243716k free, 1303824k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21901 mysql 15 0 961m 196m 3372 S 24.1 5.0 0:43.49 mysqld
21931 nobody 18 0 497m 24m 2692 S 9.2 0.6 0:18.10 httpd
23531 nobody 18 0 1319m 20m 2672 S 9.1 0.5 0:01.18 httpd
23368 nobody 18 0 493m 21m 2664 S 6.9 0.5 0:02.79 httpd
23503 nobody 18 0 1573m 21m 2656 S 6.3 0.5 0:00.96 httpd
21964 nobody 15 0 428m 23m 2692 S 6.2 0.6 0:15.79 httpd
21520 nobody 17 0 559m 24m 2696 S 5.6 0.6 0:19.99 httpd
22828 nobody 18 0 1064m 23m 2984 S 5.1 0.6 0:07.97 httpd
23698 nobody 18 0 404m 12m 2408 S 4.8 0.3 0:00.41 httpd
22328 nobody 16 0 244m 52m 31m S 1.7 1.3 0:00.87 php
22389 nobody 16 0 232m 24m 15m S 1.6 0.6 0:00.64 php
22029 nobody 15 0 232m 20m 11m S 1.5 0.5 0:00.53 php
22032 nobody 16 0 230m 26m 17m S 1.5 0.7 0:00.44 php
22360 nobody 16 0 232m 24m 15m S 1.5 0.6 0:00.39 php
22288 nobody 15 0 230m 23m 15m S 1.4 0.6 0:00.41 php
22331 nobody 15 0 230m 20m 11m S 1.4 0.5 0:00.42 php
21922 nobody 16 0 231m 20m 12m S 1.3 0.5 0:00.62 php
22066 nobody 17 0 233m 22m 12m S 1.3 0.6 0:00.59 php
22286 nobody 16 0 229m 21m 15m S 1.3 0.6 0:00.40 php
22382 nobody 15 0 231m 20m 12m S 1.2 0.5 0:00.56 php
23532 nobody 15 0 1064m 19m 2664 S 1.2 0.5 0:00.51 httpd
21959 nobody 16 0 230m 20m 11m S 1.0 0.5 0:00.42 php
22116 nobody 15 0 230m 20m 11m S 0.9 0.5 0:00.67 php
22318 nobody 15 0 231m 23m 15m S 0.7 0.6 0:00.37 php
22460 nobody 15 0 233m 25m 15m S 0.7 0.7 0:00.66 php
22461 nobody 16 0 231m 21m 11m S 0.7 0.5 0:00.44 php
21926 nobody 15 0 230m 19m 10m S 0.6 0.5 0:00.35 php
21772 nobody 15 0 228m 23m 17m S 0.5 0.6 0:00.56 php
21779 nobody 15 0 230m 23m 17m S 0.5 0.6 0:00.75 php
21962 nobody 15 0 233m 26m 16m S 0.5 0.7 0:00.72 php
22156 nobody 15 0 229m 17m 12m S 0.5 0.5 0:00.54 php
22224 nobody 15 0 232m 21m 12m S 0.5 0.5 0:00.44 php
22332 nobody 15 0 232m 25m 16m S 0.5 0.6 0:00.75 php
22334 nobody 15 0 230m 19m 11m S 0.5 0.5 0:00.35 php
22362 nobody 15 0 230m 24m 15m S 0.5 0.6 0:00.35 php
22399 nobody 15 0 230m 24m 15m S 0.5 0.6 0:00.34 php
21777 nobody 15 0 231m 20m 12m S 0.3 0.5 0:00.35 php
21993 nobody 15 0 230m 22m 15m S 0.3 0.6 0:00.60 php
22064 nobody 16 0 231m 24m 16m S 0.3 0.6 0:00.64 php
22314 nobody 15 0 231m 25m 15m S 0.3 0.6 0:00.51 php
22396 nobody 15 0 231m 20m 11m S 0.3 0.5 0:00.31 php
21781 nobody 16 0 173m 20m 15m S 0.2 0.5 0:00.44 php
22031 nobody 15 0 233m 26m 16m S 0.2 0.7 0:00.59 php
22034 nobody 15 0 232m 21m 11m S 0.2 0.5 0:00.57 php
22035 root 15 0 12992 1440 832 R 0.2 0.0 0:01.22 top
22155 nobody 15 0 230m 20m 11m S 0.2 0.5 0:00.55 php
22285 nobody 16 0 229m 17m 11m S 0.2 0.5 0:00.55 php
22298 nobody 16 0 227m 24m 18m S 0.2 0.6 0:00.66 php
22306 nobody 15 0 229m 17m 11m S 0.2 0.4 0:00.53 php
22312 nobody 15 0 232m 24m 16m S 0.2 0.6 0:00.50 php
22321 nobody 15 0 232m 19m 11m S 0.2 0.5 0:00.25 php
22327 nobody 15 0 227m 21m 15m S 0.2 0.5 0:00.33 php
22329 nobody 15 0 233m 24m 15m S 0.2 0.6 0:00.35 php
22333 nobody 16 0 230m 20m 11m S 0.2 0.5 0:00.39 php
22365 nobody 15 0 232m 20m 11m S 0.2 0.5 0:00.31 php


------------------------------------------------------------------------
HTTPD.CONF
KeepAlive Off
MaxKeepAliverequests 0
KeepAliveTimeout 5
<IfModule worker.c>
MinSpareThreads 25
MaxSpareThreads 75
</IfModule>

Timeout 300
TraceEnable On
ServerSignature Off
ServerTokens Full
FileETag All
StartServers 10
<IfModule prefork.c>
MinSpareServers 10
MaxSpareServers 20
</IfModule>

MaxClients 250
MaxRequestsPerChild 5000
ThreadsPerChild 25
------------------------------------

MY.CNF

datadir=/home/mysql
skip-locking
skip-innodb
safe-show-database

query_cache_limit=1M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1

max_user_connections=200
max_connections=200

interactive_timeout=10
wait_timeout=30
connect_timeout=20

thread_cache_size=64
key_buffer=300M ## 64MB for every 1GB of RAM
join_buffer=3M
max_connect_errors=20
max_allowed_packet=16M
table_cache=3096
record_buffer=1M

sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM

thread_concurrency=16 ## Number of CPUs x 2

myisam_sort_buffer_size=256M
server-id=1

long_query_time = 10
log-slow-queries = /var/lib/mysql/slow_queries.log
#log-queries-not-using-indexes

[mysqld_safe]
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=256M
sort_buffer=256M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=256M
sort_buffer=256M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

---------------------------
CARACTERISTICAS DEL SERVIDOR

Total processors: 8

Processor #1

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
2000.000 MHz

Cache
4096 KB

Processor #2

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
1600.000 MHz

Cache
4096 KB

Processor #3

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
1600.000 MHz

Cache
4096 KB

Processor #4

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
1600.000 MHz

Cache
4096 KB

Processor #5

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
1600.000 MHz

Cache
4096 KB

Processor #6

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
2000.000 MHz

Cache
4096 KB

Processor #7

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
1600.000 MHz

Cache
4096 KB

Processor #8

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz

Speed
1600.000 MHz

Cache
4096 KB


Memory Information

Memory for crash kernel (0x0 to 0x0) notwithin permissible range
Memory: 4032492k/5242880k available (2574k kernel code, 152656k reserved, 1304k data, 212k init)