Ver Mensaje Individual
  #1 (permalink)  
Antiguo 08/11/2006, 05:24
Copp
 
Fecha de Ingreso: junio-2002
Mensajes: 516
Antigüedad: 21 años, 10 meses
Puntos: 0
Optimizar Carga en server para web

Hola.

Queria que me recomendaraios configuraciones de mysql y apache para optimizar mas la carga. Os poco aqui los datos.

Datos servidor:

Intel(R) Xeon(TM) CPU 2.40GHz
HD: 75 gb x 2 SCASI
2 GB RAM

Datos web: (en phpnuke)

La web tiene unas 30.000 visitas unicas diarias. A partir de la 1 pm, suelen haber conectados 1.000 usuarios, y a lo largo de la tarde sube hasta los 1.500 users online.

Datos de carga:

Desde la 1 pm hasta las 12 pm mas o menos, el load average suele estar en 8.00, 10.00, hasta los 12.00 mas o menos.
La CPU suele estar bastante alta, 60%, 80%......

Configuracion mysql:

[mysql.server]
user=mysql
basedir=/var/lib
connect_timeout=10
interactive_timeout=10
join_buffer_size=1M
key_buffer=400M
record_buffer=1M
max_allowed_packet=16M
max_connections=2000
max_connect_errors=5
myisam_sort_buffer_size=64M
read_buffer_size=2M
read_rnd_buffer_size=768K
sort_buffer_size=2M
table_cache=1024
thread_cache_size=200
thread_concurrency=2
wait_timeout=10
query_cache_size=300M
query_cache_limit=10M
query_cache_type=1
safe-show-database

configuracion httpd:

# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 1000

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000
</IfModule>

# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 5
MaxClients 600
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>

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

Podria de alguna forma mejorar el rendimiento del server?

Saludos

Última edición por Copp; 10/11/2006 a las 03:11