Ver Mensaje Individual
  #7 (permalink)  
Antiguo 11/03/2008, 17:02
nuss
 
Fecha de Ingreso: febrero-2006
Mensajes: 22
Antigüedad: 18 años, 8 meses
Puntos: 0
Re: Como medir la capacidad de un servidor

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