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? 
   
 








