Ver Mensaje Individual
  #12 (permalink)  
Antiguo 12/03/2008, 15:50
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

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