|
Mysql status
MySQL 5.0.51a-24+lenny4 uptime 0 4:47:36 Sun Sep 5 09:50:02 2010
__ Key _________________________________________________________________
Buffer used 71.50M of 256.00M %Used: 27.93
Current 96.87M %Usage: 37.84
Write ratio 0.327
Read ratio 0.007
__ Questions ___________________________________________________________
Total 379.99k 22.0/s
DMS 207.73k 12.0/s %Total: 54.67
QC Hits 101.47k 5.9/s 26.70
Com_ 42.95k 2.5/s 11.30
COM_QUIT 29.14k 1.7/s 7.67
-Unknown 1.31k 0.1/s 0.35
Slow 291 0.0/s 0.08 %DMS: 0.14
DMS 207.73k 12.0/s 54.67
SELECT 172.40k 10.0/s 45.37 82.99
UPDATE 16.77k 1.0/s 4.41 8.07
INSERT 9.75k 0.6/s 2.57 4.69
DELETE 5.92k 0.3/s 1.56 2.85
REPLACE 2.88k 0.2/s 0.76 1.39
Com_ 42.95k 2.5/s 11.30
change_db 24.99k 1.4/s 6.58
set_option 12.61k 0.7/s 3.32
admin_comma 2.49k 0.1/s 0.66
__ SELECT and Sort _____________________________________________________
Scan 28.43k 1.6/s %SELECT: 16.49
Range 6.85k 0.4/s 3.97
Full join 1.23k 0.1/s 0.71
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 13.61k 0.8/s
Sort range 12.86k 0.7/s
Sort mrg pass 2 0.0/s
__ Query Cache _________________________________________________________
Memory usage 69.52M of 128.00M %Used: 54.31
Block Fragmnt 2.91%
Hits 101.47k 5.9/s
Inserts 157.03k 9.1/s
Insrt:Prune 157.03k:1 9.1/s
Hit:Insert 0.65:1
__ Table Locks _________________________________________________________
Waited 932 0.1/s %Total: 0.37
Immediate 253.69k 14.7/s
__ Tables ______________________________________________________________
Open 937 of 1024 %Cache: 91.50
Opened 7.08k 0.4/s
__ Connections _________________________________________________________
Max used 74 of 220 %Max: 33.64
Total 29.25k 1.7/s
__ Created Temp ________________________________________________________
Disk table 5.93k 0.3/s
Table 12.12k 0.7/s
File 19 0.0/s
__ Threads _____________________________________________________________
Running 4 of 9
Cached 59 of 64 %Hit: 99.75
Created 74 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 208 0.0/s
Connects 41 0.0/s
__ Bytes _______________________________________________________________
Sent 11.01G 638.0k/s
Received 691.82M 40.1k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 6.34M of 8.00M %Used: 79.30
Read ratio 0.003
Pages
Free 106 %Total: 20.70
Data 404 78.91 %Drty: 0.00
Misc 2 0.39
Latched 0 0.00
Reads 122.97k 7.1/s
From file 322 0.0/s 0.26
Ahead Rnd 10 0.0/s
Ahead Sql 0 0/s
Writes 59 0.0/s
Flushes 14 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 361 0.0/s
Writes 34 0.0/s
fsync 25 0.0/s
Pending
Reads 0
Writes 0
fysnc 0
Pages
Created 0 0/s
Read 404 0.0/s
Written 14 0.0/s
Rows
Deleted 3 0.0/s
Inserted 3 0.0/s
Read 42.19k 2.4/s
Updated 2 0.0/s
|
