Como medir la capacidad de un servidor

nuss · #1 (**permalink**) 09/03/2008, 22:23

Que tal un saludo a todos,

Les comento actualmente tengo un servidor dedicado en el cual hosteo mi sitio, actualmente estoy teneindo algunos problemas de performance, y me surge la duda, de como hago para saber hasta que punto me puede servir mi server actual.

Detalle del servidor:

AMD Athlon 3800
3GB de RAM
Disco SATA 80Gb
10mbits de conexion

Corre con Fedora 5.

En el server tengo instalado:

Apache 2.2.x
Mysql 5.0xx
PHP 4.4.x

Y nada más.

El server está en un datacenter (layeredtech.com) de USA.

Mi sitio es un foro realizado con vbulletin (igual que este), y tengo aproximadamente 15.000 visitas unicas al dia.

Hasta aqui todo bien, digamos que no es la pagina mas rapida en cargar del mundo pero es perfectamente navegable.

El problema empezo hace poco, cuando empezé a experimentar picos de mas de 400 personas conectadas simultaneamente, esto basicamente me está tirando todo abajo, la navegación en al pagina se vuelve imposible.

Esto obviamente me perjudica muchisimo y por eso estoy pensando en Cambiar el server por uno mas potente, pero antes de hacerlo me gustaria, si alguien puede que me aconseje que parametros debo mirar en el servidor, sabiendo que el piso minimo es de 15.000 visitas diarias y espero si todo marcha bien, llevarla a un minimo de 20.000 durante este año.

Tambien hay que tener en cuenta que vbulletin, no es un sistema "liviano"

Les agradezco uan respuesta

Saludos!!

Datacenter1 · #2 (**permalink**) 10/03/2008, 06:53

Puedes optimizar php, Apache y MySQl
Instalar un cache de PHP ayudará muchisimo también, recomiendo eaccelerator

Si posteas tus valores de /etc/my.cnf y tu archivo httpd.conf con gusto te doy una mano

En el peor de los casos si el server ya está optimizado al máximo, deberás adquirir un server más potente o mejor aún adquirir otro y mover la parte web a uno y mysql en otro

nuss · #3 (**permalink**) 10/03/2008, 18:40

Aqui están los valores, desde ya muchisimas gracias :)

my.cnf

Cita:

[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
set-variable = max_allowed_packet=6M
set-variable = max_connections=1500

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

nuss · #4 (**permalink**) 10/03/2008, 18:45

Perdon por 2 post seguidos, pero no me alcanzaban los caracteres.

httpd.conf

Cita:

AccessFileName .htaccess

Timeout 5
KeepAlive Off

<IfModule prefork.c>
StartServers 4
MinSpareServers 3
MaxSpareServers 6
ServerLimit 100
MaxClients 150
MaxRequestsPerChild 0
RLimitCPU 10 20
#RLimitMEM 52428800 62914560
RLimitNPROC 5 10
</IfModule>

LoadModule evasive20_module /usr/lib64/httpd/modules/mod_evasive20.so

<IfModule mod_evasive20.c>
DOSHashTableSize 3097
DOSPageCount 30
DOSSiteCount 50
DOSPageInterval 5
DOSSiteInterval 10
DOSBlockingPeriod 3600
DOSBlockingPeriod 3600
#bots de google - rangos de ip
DOSWhitelist 66.249.65.*
DOSWhitelist 66.249.66.*
</IfModule>

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
ServerRoot "/usr/local/apache2"

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#Listen 12.34.56.78:80
Listen 80

#
# Dynamic Shared Object (DSO) Support
# Example:
# LoadModule foo_module modules/mod_foo.so
LoadModule php4_module modules/libphp4.so
#

<IfModule !mpm_netware_module>
<IfModule !mpm_winnt_module>

User apache
Group apache

</IfModule>
</IfModule>

ServerAdmin [email protected]

#ServerName www.example.com:80

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot /home

#
# Each directory to which Apache has access can be configured with respect
# to which services and features are allowed and/or disabled in that
# directory (and its subdirectories).

<Directory />
Options FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
</Directory>

#
# This should be changed to whatever you set DocumentRoot to.
#
<Directory "/home">

Options Indexes FollowSymLinks

#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#
AllowOverride None

#
# Controls who can get stuff from this server.
#
Order allow,deny
Allow from all

</Directory>

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
DirectoryIndex index.html index.php
</IfModule>

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^\.ht">
Order allow,deny
Deny from all
Satisfy All
</FilesMatch>

# ScriptAlias: This controls which directories contain server scripts.
#
ScriptAlias /cgi-bin/ "/usr/local/apache2/cgi-bin/"

</IfModule>

#
# "/usr/local/apache2/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "/usr/local/apache2/cgi-bin">
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

#
# DefaultType: the default MIME type the server will use for a document

DefaultType text/plain

<IfModule mime_module>
#
# TypesConfig points to the file containing the list of mappings from
# filename extension to MIME-type.
#
TypesConfig conf/mime.types

#
# AddType allows you to add to or override the MIME configuration
# file specified in TypesConfig for specific file types.
#
#AddType application/x-gzip .tgz
#
# AddEncoding allows you to have certain browsers uncompress
# information on the fly. Note: Not all browsers support this.
#
#AddEncoding x-compress .Z
#AddEncoding x-gzip .gz .tgz
#
# If the AddEncoding directives above are commented-out, then you
# probably should define those extensions to indicate media types:
#
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz

#
# AddHandler allows you to map certain file extensions to "handlers":
# actions unrelated to filetype. These can be either built into the server
# or added with the Action directive (see below)
#
# To use CGI scripts outside of ScriptAliased directories:
# (You will also need to add "ExecCGI" to the "Options" directive.)
#
#AddHandler cgi-script .cgi

# For type maps (negotiated resources):
#AddHandler type-map var

#
# Filters allow you to process content before it is sent to the client.
#
# To parse .shtml files for server-side includes (SSI):
# (You will also need to add "Includes" to the "Options" directive.)
#
#AddType text/html .shtml
#AddOutputFilter INCLUDES .shtml
</IfModule>
NameVirtualHost 11.111.111.111:80

# Server-pool management (MPM specific)
#Include conf/extra/httpd-mpm.conf

# Multi-language error messages
#Include conf/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
#Include conf/extra/httpd-autoindex.conf

# Language settings
#Include conf/extra/httpd-languages.conf

# User home directories
#Include conf/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include conf/extra/httpd-info.conf

# Virtual hosts
#Include conf/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include conf/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include conf/extra/httpd-dav.conf

# Various default settings
#Include conf/extra/httpd-default.conf

# Secure (SSL/TLS) connections
#Include conf/extra/httpd-ssl.conf
#
# Note: The following must must be present to support
# starting without SSL on platforms with no /dev/random equivalent
# but a statically compiled-in mod_ssl.
#

AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
AddType application/x-httpd-php .phtml
AddType application/x-httpd-php .php3
AddType application/x-httpd-perl .pl .p
AddType application/x-httpd-php .php4

<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>
<VirtualHost 11.111.111.111:80>
ServerName FFFFFFFFF.com
ServerAlias www.FFFFFFFFF.com
DocumentRoot /home/XXXXXXXX/public_html/english
ErrorLog /home/FFFFFFFFF/logs/error_log
CustomLog /home/FFFFFFFFF/logs/access_log combined
ScriptAlias /cgi-bin/ /home/FFFFFFFFF/cgi-bin/
<Directory "/home/XXXXXXXX/public_html/english">
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/FFFFFFFFF/cgi-bin>
allow from all
</Directory>
</VirtualHost>
<VirtualHost 11.111.111.111:80>
ServerName XXXXXXXX.com.ar
ServerAlias www.XXXXXXXX.com.ar
DocumentRoot /home/XXXXXXXX/public_html
ErrorLog /home/XXXXXXXX/logs/error_log
CustomLog /home/XXXXXXXX/logs/access_log combined
ScriptAlias /cgi-bin/ /home/XXXXXXXX/cgi-bin/
<Directory /home/XXXXXXXX/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/XXXXXXXX/cgi-bin>
allow from all
</Directory>
</VirtualHost>
<VirtualHost 11.111.111.111:80>
ServerName VVVVVVVVV.com.ar
ServerAlias www.VVVVVVVVV.com.ar
DocumentRoot /home/VVVVVVVVV/public_html
ErrorLog /home/VVVVVVVVV/logs/error_log
CustomLog /home/VVVVVVVVV/logs/access_log combined
ScriptAlias /cgi-bin/ /home/VVVVVVVVV/cgi-bin/
<Directory /home/VVVVVVVVV/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/VVVVVVVVV/cgi-bin>
allow from all
</Directory>
</VirtualHost>
<VirtualHost 11.111.111.111:80>
ServerName ads.XXXXXXXX.com.ar
ServerAlias www.ads.XXXXXXXX.com.ar
DocumentRoot /home/ads/public_html
ErrorLog /home/ads/logs/error_log
CustomLog /home/ads/logs/access_log combined
ScriptAlias /cgi-bin/ /home/ads/cgi-bin/
<Directory /home/ads/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/ads/cgi-bin>
allow from all
</Directory>
</VirtualHost>
<VirtualHost 11.111.111.111:80>
ServerName imagenes.XXXXXXXX.com.ar
ServerAlias www.imagenes.XXXXXXXX.com.ar
DocumentRoot /home/imagenes/public_html
ErrorLog /home/imagenes/logs/error_log
CustomLog /home/imagenes/logs/access_log combined
ScriptAlias /cgi-bin/ /home/imagenes/cgi-bin/
<Directory /home/imagenes/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/imagenes/cgi-bin>
allow from all
</Directory>
</VirtualHost>
<VirtualHost 11.111.111.111:80>
ServerName tracker.XXXXXXXX.com.ar
ServerAlias www.tracker.XXXXXXXX.com.ar
DocumentRoot /home/tracker/public_html
ErrorLog /home/tracker/logs/error_log
CustomLog /home/tracker/logs/access_log combined
ScriptAlias /cgi-bin/ /home/tracker/cgi-bin/
<Directory /home/tracker/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/tracker/cgi-bin>
allow from all
</Directory>
</VirtualHost>
<VirtualHost 11.111.111.111:80>
ServerName ddddddd.YYYYYYYYYYY
ServerAlias www.dddddddd.YYYYYYYYYYY
DocumentRoot /home/dddddddd/public_html
ErrorLog /home/dddddddd/logs/error_log
CustomLog /home/dddddddd/logs/access_log combined
ScriptAlias /cgi-bin/ /home/dddddddd/cgi-bin/
<Directory /home/dddddddd/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
AllowOverride All
</Directory>
<Directory /home/dddddddd/cgi-bin>
allow from all
</Directory>
</VirtualHost>

Datacenter1 · #5 (**permalink**) 11/03/2008, 08:04

Cambia tu my.cnf por este, no incluye todo lo que se puede hacer pero nos dará un punto de partida

Código:

[mysqld]
socket=/var/lib/mysql/mysql.sock
local-infile
old-passwords
safe-show-database
low-priority-updates
symbolic-links
#log-error=/var/log/mysql/error.log
#log-slow-queries=/var/log/mysql/slowquery.log
long_query_time=5
query_cache_type = 1
connect_timeout=10
max_connections=1000
max_user_connections=1000
max_connect_errors=20
max_allowed_packet=8M
key_buffer=512M
myisam_sort_buffer_size=64M
join_buffer=2M
record_buffer=8M
sort_buffer=2M
table_cache=22000
thread_cache_size=256
wait_timeout=1800
tmp_table_size=64M
query_cache_size=512M
query_cache_limit=16M
open_files_limit=60000

[safe_mysqld]
open_files_limit=60000

[mysqldump]
socket=/var/lib/mysql/mysql.sock
max_allowed_packet=16M
add-drop-table
extended-insert
quick

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

[mysql]
socket=/var/lib/mysql/mysql.sock
disable-auto-rehash
connect_timeout=10
local-infile
quick
#unbuffered
#silent

[client]
port=3306
socket=/var/lib/mysql/mysql.sock

esto debe comenzar a bajar la carga MySQL, para obtener más información acerca del uso actual que tiene tu servidor MySQL te recomiendo un excelente script http://hackmysql.com/mysqlreport si puedes instálalo antes de cambiar algo y lo corres para ver el performace actual.

Luego de ver los resultados haremos algunos ajustes, considera instalar eaccelerator.

P.D. Esto lo hago a modo de colaboración y no me hago responsable por cualquier efecto indeseado que alguna modificación pueda ocasionar, se debe realizar un backup antes de modificar cualquier archivo.

nuss · #6 (**permalink**) 11/03/2008, 16:31

Muchas gracias por el my.cnf modificado, no sabes cuanto te agradezco.

Este es my MYSQLREPORT Actual, sin las modificacionbes que me enviaste.
Ahora voya reemplzar el my.cnf y posteo el nuevo reporte.

Cita:

MySQL 5.0.27 uptime 0 21:57:5 Tue Mar 11 17:35:17 2008

__ Key __________________________________________________ _______________
Buffer used 6.54M of 8.00M %Used: 81.76
Current 4.04M %Usage: 50.54
Write hit 53.39%
Read hit 99.51%

__ Questions __________________________________________________ _________
Total 4.44M 56.2/s
DMS 3.14M 39.8/s %Total: 70.77
Com_ 834.93k 10.6/s 18.81
COM_QUIT 427.60k 5.4/s 9.63
+Unknown 35.06k 0.4/s 0.79
Slow (10) 203 0.0/s 0.00 %DMS: 0.01 Log: OFF
DMS 3.14M 39.8/s 70.77
SELECT 2.78M 35.2/s 62.71 88.60
UPDATE 281.87k 3.6/s 6.35 8.97
INSERT 61.10k 0.8/s 1.38 1.94
DELETE 10.92k 0.1/s 0.25 0.35
REPLACE 4.29k 0.1/s 0.10 0.14
Com_ 834.93k 10.6/s 18.81
change_db 771.09k 9.8/s 17.37
set_option 61.68k 0.8/s 1.39
lock_tables 380 0.0/s 0.01

__ SELECT and Sort __________________________________________________ ___
Scan 958.94k 12.1/s %SELECT: 34.44
Range 434.32k 5.5/s 15.60
Full join 85 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 352.09k 4.5/s
Sort range 143.00k 1.8/s
Sort mrg pass 4 0.0/s

__ Table Locks __________________________________________________ _______
Waited 14.37k 0.2/s %Total: 0.37
Immediate 3.85M 48.7/s

__ Tables __________________________________________________ ____________
Open 64 of 64 %Cache: 100.00
Opened 123.16k 1.6/s

__ Connections __________________________________________________ _______
Max used 263 of 1500 %Max: 17.53
Total 427.60k 5.4/s

__ Created Temp __________________________________________________ ______
Disk table 6.28k 0.1/s
Table 72.93k 0.9/s Size: 32.0M
File 13 0.0/s

__ Threads __________________________________________________ ___________
Running 1 of 95
Cached 0 of 0 %Hit: 0
Created 427.60k 5.4/s
Slow 2428 0.0/s

__ Aborted __________________________________________________ ___________
Clients 2 0.0/s
Connects 277 0.0/s

__ Bytes __________________________________________________ _____________
Sent 577.28G 7.3M/s
Received 718.97M 9.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 7.39M of 8.00M %Used: 92.38
Read hit 97.50%
Pages
Free 39 %Total: 7.62
Data 471 91.99 %Drty: 0.00
Misc 2 0.39
Latched 0 0.00
Reads 11.90k 0.2/s
From file 297 0.0/s 2.50
Ahead Rnd 19 0.0/s
Ahead Sql 1 0.0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 344 0.0/s
Writes 3 0.0/s
fsync 3 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 471 0.0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

nuss · #7 (**permalink**) 11/03/2008, 17:02

Aquí está el contenido utilizando el nuevo my.cnf

Estoy notando una mejora de entre un 5 y 10 % en la navegabilidad del sitio, pero todavia le falta para estar en un nivel optimo.

Cita:

MySQL 5.0.27 uptime 0 0:19:20 Tue Mar 11 18:01:22 2008

__ Key __________________________________________________ _______________
Buffer used 7.34M of 512.00M %Used: 1.43
Current 100.70M %Usage: 19.67
Write hit 43.37%
Read hit 99.53%

__ Questions __________________________________________________ _________
Total 81.31k 70.1/s
QC Hits 30.18k 26.0/s %Total: 37.12
DMS 26.13k 22.5/s 32.14
Com_ 16.20k 14.0/s 19.93
COM_QUIT 8.33k 7.2/s 10.24
+Unknown 467 0.4/s 0.57
Slow (5) 13 0.0/s 0.02 %DMS: 0.05 Log: OFF
DMS 26.13k 22.5/s 32.14
SELECT 19.99k 17.2/s 24.59 76.51
UPDATE 4.86k 4.2/s 5.98 18.59
INSERT 1.13k 1.0/s 1.39 4.32
DELETE 82 0.1/s 0.10 0.31
REPLACE 70 0.1/s 0.09 0.27
Com_ 16.20k 14.0/s 19.93
change_db 14.48k 12.5/s 17.81
set_option 1.71k 1.5/s 2.10
lock_tables 4 0.0/s 0.00

__ SELECT and Sort __________________________________________________ ___
Scan 4.77k 4.1/s %SELECT: 23.86
Range 2.55k 2.2/s 12.77
Full join 36 0.0/s 0.18
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 2.29k 2.0/s
Sort range 2.22k 1.9/s
Sort mrg pass 0 0/s

__ Query Cache __________________________________________________ _______
Memory usage 21.40M of 512.00M %Used: 4.18
Block Fragmnt 5.95%
Hits 30.18k 26.0/s
Inserts 15.70k 13.5/s
Insrt:Prune 15.70k:1 13.5/s
Hit:Insert 1.92:1

__ Table Locks __________________________________________________ _______
Waited 58 0.1/s %Total: 0.16
Immediate 36.72k 31.7/s

__ Tables __________________________________________________ ____________
Open 226 of 2200 %Cache: 1.03
Opened 240 0.2/s

__ Connections __________________________________________________ _______
Max used 65 of 1000 %Max: 6.50
Total 8.33k 7.2/s

__ Created Temp __________________________________________________ ______
Disk table 151 0.1/s
Table 1.10k 0.9/s Size: 64.0M
File 5 0.0/s

__ Threads __________________________________________________ ___________
Running 2 of 22
Cached 43 of 256 %Hit: 99.22
Created 65 0.1/s
Slow 3 0.0/s

__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 1 0.0/s

__ Bytes __________________________________________________ _____________
Sent 10.65G 9.2M/s
Received 13.91M 12.0k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 448.00k of 8.00M %Used: 5.47
Read hit 93.60%
Pages
Free 484 %Total: 94.53
Data 28 5.47 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 328 0.3/s
From file 21 0.0/s 6.40
Ahead Rnd 1 0.0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 34 0.0/s
Writes 3 0.0/s
fsync 3 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 28 0.0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

Datacenter1 · #8 (**permalink**) 11/03/2008, 21:54

No esperaba mucha mejoria, pero ahora tenemos más datos para trabajar, mañana apenas saque un tiempo libre, veo en que podemos mejorar un poco tu configuración

nuss · #9 (**permalink**) 12/03/2008, 06:48

Cita:

Iniciado por Datacenter1

No esperaba mucha mejoria, pero ahora tenemos más datos para trabajar, mañana apenas saque un tiempo libre, veo en que podemos mejorar un poco tu configuración

Muchas gracias nuevamente, no sabés cuanto aprecio que me dediques unos minutos de tu tiempo!!

Tambien queria contarte que instale el Eaccelerator, y si se nota una mejoria mucho mayor ahora, auqnue sigo con quejas de lentitud por aprte de algunos users

Datacenter1 · #10 (**permalink**) 12/03/2008, 07:02

Eaccelerator te ayudará a ganar velocidad y bajar el uso de MySQL, puedes probar incrementando el cache: a 256 o incluso 512

Código:

 eaccelerator.shm_size="256"

Existe también un plugin de vbulletin que permite utilizar un cache más eficiente, busca en el foro de vbulletin.org (no recuerdo el nombre del plugin) lo llegué a usar con buenos resultados.

Datacenter1 · #11 (**permalink**) 12/03/2008, 11:13

Puedes volver a correr el mysqlreport y publicar la salida para ver como ha estado el uso con carga real y darte las sugerencias finales para el my.cnf ?

nuss · #12 (**permalink**) 12/03/2008, 15:50

Claro aqui está:

Cita:

MySQL 5.0.27 uptime 0 4:45:25 Wed Mar 12 16:56:29 2008

__ Key __________________________________________________ _______________
Buffer used 22.12M of 512.00M %Used: 4.32
Current 115.49M %Usage: 22.56
Write hit 53.53%
Read hit 99.90%

__ Questions __________________________________________________ _________
Total 1.23M 71.8/s
QC Hits 496.28k 29.0/s %Total: 40.33
DMS 344.73k 20.1/s 28.02
Com_ 255.10k 14.9/s 20.73
COM_QUIT 128.43k 7.5/s 10.44
+Unknown 5.87k 0.3/s 0.48
Slow (5) 37 0.0/s 0.00 %DMS: 0.01 Log: OFF
DMS 344.73k 20.1/s 28.02
SELECT 257.32k 15.0/s 20.91 74.65
UPDATE 70.30k 4.1/s 5.71 20.39
INSERT 13.31k 0.8/s 1.08 3.86
DELETE 2.77k 0.2/s 0.23 0.80
REPLACE 1.02k 0.1/s 0.08 0.30
Com_ 255.10k 14.9/s 20.73
change_db 235.08k 13.7/s 19.11
set_option 19.79k 1.2/s 1.61
lock_tables 79 0.0/s 0.01

__ SELECT and Sort __________________________________________________ ___
Scan 52.49k 3.1/s %SELECT: 20.40
Range 32.13k 1.9/s 12.49
Full join 14 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 27.95k 1.6/s
Sort range 29.03k 1.7/s
Sort mrg pass 1 0.0/s

__ Query Cache __________________________________________________ _______
Memory usage 39.97M of 512.00M %Used: 7.81
Block Fragmnt 12.95%
Hits 496.28k 29.0/s
Inserts 206.79k 12.1/s
Insrt:Prune 206.79k:1 12.1/s
Hit:Insert 2.40:1

__ Table Locks __________________________________________________ _______
Waited 277 0.0/s %Total: 0.05
Immediate 526.18k 30.7/s

__ Tables __________________________________________________ ____________
Open 389 of 2200 %Cache: 1.77
Opened 484 0.0/s

__ Connections __________________________________________________ _______
Max used 106 of 1000 %Max: 10.60
Total 128.43k 7.5/s

__ Created Temp __________________________________________________ ______
Disk table 1.31k 0.1/s
Table 13.05k 0.8/s Size: 64.0M
File 7 0.0/s

__ Threads __________________________________________________ ___________
Running 2 of 28
Cached 78 of 256 %Hit: 99.92
Created 106 0.0/s
Slow 2 0.0/s

__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 7 0.0/s

__ Bytes __________________________________________________ _____________
Sent 180.36G 10.5M/s
Received 205.99M 12.0k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 448.00k of 8.00M %Used: 5.47
Read hit 93.60%
Pages
Free 484 %Total: 94.53
Data 28 5.47 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 328 0.0/s
From file 21 0.0/s 6.40
Ahead Rnd 1 0.0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 34 0.0/s
Writes 3 0.0/s
fsync 3 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 28 0.0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

Datacenter1 · #13 (**permalink**) 12/03/2008, 20:08

Este my.cnf debe dar mejor resultado, no mucho más rendimiento pero si mejor uso de los recursos, de esta manera podrás usarlos en otro lugar (como aumentando el cache de eaccelerator tal como te sugerí)

Código:

[mysqld]
socket=/var/lib/mysql/mysql.sock
local-infile
old-passwords
safe-show-database
low-priority-updates
symbolic-links
#log-error=/var/log/mysql/error.log
#log-slow-queries=/var/log/mysql/slowquery.log
long_query_time=5
query_cache_type = 1
connect_timeout=10
max_connections=512
max_user_connections=512
max_connect_errors=20
max_allowed_packet=8M
key_buffer=128M
myisam_sort_buffer_size=64M
join_buffer=2M
record_buffer=8M
sort_buffer=4M
table_cache=1024
thread_cache_size=256
wait_timeout=1800
tmp_table_size=64M
query_cache_size=256M
query_cache_limit=16M
open_files_limit=4096

[safe_mysqld]
open_files_limit=8192

[mysqldump]
socket=/var/lib/mysql/mysql.sock
max_allowed_packet=16M
add-drop-table
extended-insert
quick

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

[mysql]
socket=/var/lib/mysql/mysql.sock
disable-auto-rehash
connect_timeout=10
local-infile
quick
#unbuffered
#silent

[client]
port=3306
socket=/var/lib/mysql/mysql.sock

Por ahora creo que no voy a sugerir cambios en tu httpd.conf quizás alguien con más experiencia con Apache2 pueda sugerirte algo (lo siento, pero soy mejor con Apache 1.X y antes de sugerirte algo que no conozco del todo, mejor no decir nada)

nuss · #14 (**permalink**) 13/03/2008, 16:14

Bueno, muchas gracias por tus consejos, ya apliqué el nuevo my.cnf, tambien aumente la cache del eacelerator a 512mb, ciertamente, estoy mucho mejor que antes!!

Datacenter1 · #15 (**permalink**) 13/03/2008, 16:30

Cita:

Iniciado por nuss

Bueno, muchas gracias por tus consejos, ya apliqué el nuevo my.cnf, tambien aumente la cache del eacelerator a 512mb, ciertamente, estoy mucho mejor que antes!!

Me alegra que te los consejos te hayan servido, solo vigila las cargas y el uso de memoria, en caso de que nadie más este dispuesto a ayudarte el httpd.conf, avísame y con gusto le daremos algún arreglo.