Ver Mensaje Individual
  #1 (permalink)  
Antiguo 25/02/2010, 14:15
malalengua
 
Fecha de Ingreso: octubre-2003
Mensajes: 153
Antigüedad: 21 años
Puntos: 5
Load Average. Servidor Dedicado

A ver, tengo un servidor dedicado con este hardware:

Processor Information

Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #1 speed: 1600.000 MHz
Processor #1 cache size: 4096 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #2 speed: 1600.000 MHz
Processor #2 cache size: 4096 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #3 speed: 1600.000 MHz
Processor #3 cache size: 4096 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #4 speed: 1600.000 MHz
Processor #4 cache size: 4096 KB


Memory Information

Memory for crash kernel (0x0 to 0x0) notwithin permissible range
Memory: 2062860k/2087808k available (2097k kernel code, 23664k reserved, 877k data, 228k init, 1170304k highmem)


System Information

Linux host.basketpc.com 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686 i686 i386 GNU/Linux


Physical Disks

SCSI device sda: 312581808 512-byte hdwr sectors (160042 MB)
sda: Write Protect is off
sda: Mode Sense: 00 3a 00 00
SCSI device sda: drive cache: write back
SCSI device sda: 312581808 512-byte hdwr sectors (160042 MB)
sda: Write Protect is off
sda: Mode Sense: 00 3a 00 00
SCSI device sda: drive cache: write back
sd 0:0:0:0: Attached scsi disk sda
SCSI device sdb: 312581808 512-byte hdwr sectors (160042 MB)
sdb: Write Protect is off
sdb: Mode Sense: 00 3a 00 00
SCSI device sdb: drive cache: write back
SCSI device sdb: 312581808 512-byte hdwr sectors (160042 MB)
sdb: Write Protect is off
sdb: Mode Sense: 00 3a 00 00
SCSI device sdb: drive cache: write back
sd 2:0:0:0: Attached scsi disk sdb
sd 0:0:0:0: Attached scsi generic sg0 type 0
sd 2:0:0:0: Attached scsi generic sg2 type 0


------------------------------------------------

Normalmente tiene una carga de entre 0.2 y 2 menos en hora punta que sube entre 3 y 4 y con picos de 5 y 6.

Os pongo aqui lo que pillé del top en un pico

top - 20:34:30 up 164 days, 12:09, 1 user, load average: 5.13, 4.29, 3.36
Tasks: 391 total, 2 running, 389 sleeping, 0 stopped, 0 zombie
Cpu(s): 49.9%us, 2.7%sy, 0.0%ni, 46.6%id, 0.3%wa, 0.1%hi, 0.3%si, 0.0%st
Mem: 2066336k total, 2009280k used, 57056k free, 16448k buffers
Swap: 2040244k total, 16644k used, 2023600k free, 292124k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
855 mysql 15 0 621m 345m 3628 S 24.2 17.1 81:30.85 mysqld
10967 nobody 15 0 66344 48m 4032 S 6.3 2.4 0:12.48 httpd
11427 nobody 15 0 59280 41m 4000 S 5.3 2.1 0:09.19 httpd
11259 nobody 15 0 56212 38m 3996 S 5.0 1.9 0:11.59 httpd
10979 nobody 15 0 57200 39m 3988 S 4.6 2.0 0:11.98 httpd
10959 nobody 15 0 54352 39m 3928 S 4.3 1.9 0:11.94 httpd
11296 nobody 15 0 53944 38m 3928 S 3.7 1.9 0:10.36 httpd
11320 nobody 15 0 59276 41m 4036 S 3.7 2.1 0:10.51 httpd
9929 nobody 15 0 55980 38m 3992 S 3.3 1.9 0:13.71 httpd
10033 nobody 15 0 54344 39m 3928 S 3.3 1.9 0:11.79 httpd
11336 nobody 15 0 56240 38m 3996 S 3.3 1.9 0:10.25 httpd
11422 nobody 15 0 53860 38m 3920 S 3.3 1.9 0:09.36 httpd
10040 nobody 15 0 54384 39m 3924 S 3.0 1.9 0:13.16 httpd
10200 nobody 16 0 56276 38m 4016 S 3.0 1.9 0:13.82 httpd
10087 nobody 15 0 59272 41m 4000 S 2.7 2.1 0:12.71 httpd
10963 nobody 15 0 56240 38m 4000 S 2.7 1.9 0:11.20 httpd
11280 nobody 16 0 56384 38m 4004 S 2.7 1.9 0:10.51 httpd
11443 nobody 16 0 56260 38m 3996 S 2.7 1.9 0:09.47 httpd
12404 nobody 15 0 56988 41m 3900 S 2.7 2.1 0:06.52 httpd
9917 nobody 15 0 55984 38m 3996 S 2.3 1.9 0:13.83 httpd
9965 nobody 15 0 54088 38m 3924 S 2.3 1.9 0:12.02 httpd
10070 nobody 15 0 56888 39m 3992 S 2.3 2.0 0:14.33 httpd
10084 nobody 15 0 56648 39m 3996 S 2.3 1.9 0:12.90 httpd
10102 nobody 15 0 53952 38m 3904 S 2.3 1.9 0:13.33 httpd
10103 nobody 15 0 56800 39m 3996 S 2.3 1.9 0:12.32 httpd
11016 nobody 15 0 56000 38m 3992 S 2.3 1.9 0:08.76 httpd
11298 nobody 15 0 53720 38m 3924 S 2.3 1.9 0:10.92 httpd
11333 nobody 15 0 53708 38m 3920 S 2.3 1.9 0:11.32 httpd
11667 nobody 15 0 53792 38m 3928 S 2.3 1.9 0:08.75 httpd
9846 nobody 16 0 56992 41m 3932 S 2.0 2.1 0:12.17 httpd
9927 nobody 15 0 56992 41m 4028 S 2.0 2.1 0:12.66 httpd
10054 nobody 15 0 59332 42m 4316 S 2.0 2.1 0:13.41 httpd
10140 nobody 15 0 56260 38m 4000 S 2.0 1.9 0:12.19 httpd
10215 nobody 15 0 56036 38m 4300 S 2.0 1.9 0:11.82 httpd
10936 nobody 15 0 54344 39m 3932 S 2.0 1.9 0:12.28 httpd
11319 nobody 15 0 56776 39m 4028 S 2.0 1.9 0:11.23 httpd
11344 nobody 15 0 56896 39m 3992 S 2.0 2.0 0:10.67 httpd
11346 nobody 15 0 53708 38m 3980 S 2.0 1.9 0:10.14 httpd
11434 nobody 15 0 59028 41m 4000 S 2.0 2.1 0:09.89 httpd
11435 nobody 15 0 65784 48m 4312 S 2.0 2.4 0:09.46 httpd
9966 nobody 15 0 56228 38m 3984 S 1.7 1.9 0:13.03 httpd
10053 nobody 15 0 56564 39m 4300 S 1.7 1.9 0:12.87 httpd
10111 nobody 15 0 58268 41m 4300 S 1.7 2.0 0:13.48 httpd
11010 nobody 15 0 53944 38m 3928 S 1.7 1.9 0:12.25 httpd
11328 nobody 15 0 56244 38m 4004 S 1.7 1.9 0:10.92 httpd
11330 nobody 15 0 56264 38m 4004 S 1.7 1.9 0:09.74 httpd
11358 nobody 15 0 56240 38m 3992 S 1.7 1.9 0:10.92 httpd
11377 nobody 15 0 53968 38m 3916 S 1.7 1.9 0:10.23 httpd
11432 nobody 15 0 56268 38m 3992 S 1.7 1.9 0:08.48 httpd
11451 nobody 15 0 56672 39m 4000 S 1.7 1.9 0:09.83 httpd
11635 nobody 15 0 59276 41m 4000 S 1.7 2.1 0:07.77 httpd
11664 nobody 15 0 59280 41m 3988 S 1.7 2.1 0:07.81 httpd
12391 nobody 15 0 54740 39m 3912 S 1.7 1.9 0:06.45 httpd

--------------------------------------------------

La configuración del my.cnf es la siguiente:

[mysqld]
skip-locking
skip-innodb
safe-show-database

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

max_user_connections=30
max_connections=150

interactive_timeout=10
wait_timeout=30
connect_timeout=20

thread_cache_size=64
key_buffer=512M ## 64MB for every 1GB of RAM
join_buffer=2M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1512
record_buffer=1M

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

thread_concurrency=8 ## 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
~
---------------------------------------------

Esta configuración del my.cnf hizo que bajara en 2 puntos la carga del servidor que andaba desde las 20:15 hast las 20:50 entre 5 y 6. Con esta nueva configuracion del my.cnf bajó entre 2 y 4 con picos preopucantes com oel que he puesto antes

--------------------------------------------
La configuración del apache es la siguiente: (coloco lo más significativo)




RLimitMEM 292394325
RLimitCPU 240
KeepAlive On
MaxKeepAliveRequests 0
KeepAliveTimeout 5
UseCanonicalName Off

TraceEnable On
ServerSignature Off
ServerTokens Full
FileETag All
StartServers 5
<IfModule prefork.c>
MinSpareServers 10
MaxSpareServers 10
</IfModule>
MaxClients 256
MaxRequestsPerChild 500


------

ESTOS PICOS SE PRODUCEN CUANDO HAY 300 USUARIOS ONLINE A LA VEZ realizando acciones en la web.

¿que he de hacer? ¿Problema de configuracion? ¿Porblema de que el servidor no da mas de si?