Ver Mensaje Individual
  #6 (permalink)  
Antiguo 11/03/2008, 16:31
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

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