20 Aug
MySQL 5.0.44 uptime 21 1:28:23 Fri Aug 20 12:04:24 2010
__ Key _________________________________________________________________
Buffer used 14.16M of 16.00M %Used: 88.48
Current 2.10M %Usage: 13.13
Write hit 96.45%
Read hit 98.52%
__ Questions ___________________________________________________________
Total 21.15M 11.6/s
DMS 14.03M 7.7/s %Total: 66.34
Com_ 5.46M 3.0/s 25.79
+Unknown 942.73k 0.5/s 4.46
COM_QUIT 721.89k 0.4/s 3.41
Slow 10 s 9.32k 0.0/s 0.04 %DMS: 0.07 Log: OFF
DMS 14.03M 7.7/s 66.34
SELECT 12.10M 6.6/s 57.21 86.23
UPDATE 1.12M 0.6/s 5.29 7.97
INSERT 506.35k 0.3/s 2.39 3.61
DELETE 304.68k 0.2/s 1.44 2.17
REPLACE 2.46k 0.0/s 0.01 0.02
Com_ 5.46M 3.0/s 25.79
set_option 1.92M 1.1/s 9.10
show_fields 937.96k 0.5/s 4.43
show_create 930.10k 0.5/s 4.40
__ SELECT and Sort _____________________________________________________
Scan 4.44M 2.4/s %SELECT: 36.69
Range 467.67k 0.3/s 3.86
Full join 7.68k 0.0/s 0.06
Range check 0 0/s 0.00
Full rng join 98.09k 0.1/s 0.81
Sort scan 1.31M 0.7/s
Sort range 636.59k 0.3/s
Sort mrg pass 85.77k 0.0/s
__ Table Locks _________________________________________________________
Waited 3.87k 0.0/s %Total: 0.02
Immediate 16.26M 8.9/s
__ Tables ______________________________________________________________
Open 64 of 64 %Cache: 100.00
Opened 2.04M 1.1/s
__ Connections _________________________________________________________
Max used 101 of 100 %Max: 101.00
Total 721.93k 0.4/s
__ Created Temp ________________________________________________________
Disk table 2.77M 1.5/s
Table 4.14M 2.3/s Size: 32.0M
File 154.94k 0.1/s
__ Threads _____________________________________________________________
Running 2 of 3
Cached 0 of 0 %Hit: 0
Created 721.93k 0.4/s
Slow 191 0.0/s
__ Aborted _____________________________________________________________
Clients 70 0.0/s
Connects 6.99k 0.0/s
__ Bytes _______________________________________________________________
Sent 1.48G 813.3/s
Received 3.87G 2.1k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 0 of 0 %Used: 0.00
Read hit 0.00%
Pages
Free 0 %Total: 0.00
Data 0 0.00 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 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 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
23 May
23 May
23 May
23 May
23 May
23 May
23 May
Recent Comments