hi,
this is the result of mysqlreport (mysql 5 + php5 [PEAR:DB] )
why com_ (change_db) is so high???
I’d appreciate any other recommendations
thank you very much
__ Key ____________________________________________________________ _____
Buffer used 246.00k of 16.00M %Used: 1.50
Current 1.95M %Usage: 12.16
Write hit 100.00%
Read hit 99.74%
__ Questions ___________________________________________________________
Total 62.71M 175.2/s
Com_ 31.36M 87.6/s %Total: 50.00
QC Hits 24.02M 67.1/s 38.30
DMS 6.42M 18.0/s 10.24
COM_QUIT 905.34k 2.5/s 1.44
+Unknown 6.05k 0.0/s 0.01
Slow 5 s 11.52k 0.0/s 0.02 %DMS: 0.18 Log: ON
DMS 6.42M 18.0/s 10.24
SELECT 5.94M 16.6/s 9.48 92.54
UPDATE 476.13k 1.3/s 0.76 7.41
INSERT 2.53k 0.0/s 0.00 0.04
DELETE 440 0.0/s 0.00 0.01
REPLACE 0 0/s 0.00 0.00
Com_ 31.36M 87.6/s 50.00
change_db 31.35M 87.6/s 49.99
set_option 2.60k 0.0/s 0.00
show_fields 2.04k 0.0/s 0.00
__ SELECT and Sort _____________________________________________________
Scan 303.36k 0.8/s %SELECT: 5.10
Range 1.13M 3.2/s 18.99
Full join 64 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 898.94k 2.5/s
Sort range 2.33M 6.5/s
Sort mrg pass 3.21k 0.0/s
__ Query Cache _________________________________________________________
Memory usage 84.89M of 128.00M %Used: 66.32
Block Fragmnt 20.68%
Hits 24.02M 67.1/s
Inserts 5.37M 15.0/s
Insrt:Prune 12.76:1 13.8/s
Hit:Insert 4.47:1
__ Table Locks _________________________________________________________
Waited 38 0.0/s %Total: 0.00
Immediate 13.57M 37.9/s
__ Tables ____________________________________________________________ __
Open 1076 of 2048 %Cache: 52.54
Opened 1.08k 0.0/s
__ Connections _________________________________________________________
Max used 36 of 90 %Max: 40.00
Total 905.34k 2.5/s
__ Created Temp ________________________________________________________
Disk table 636.01k 1.8/s
Table 2.50M 7.0/s Size: 128.0M
File 2.10k 0.0/s
__ Threads ____________________________________________________________ _
Running 4 of 4
Cached 32 of 64 %Hit: 100
Created 36 0.0/s
Slow 0 0/s
__ Aborted ____________________________________________________________ _
Clients 0 0/s
Connects 1 0.0/s
__ Bytes ____________________________________________________________ ___
Sent 177.42M 495.8/s
Received 1.58G 4.4k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 763.08M of 900.00M %Used: 84.79
Read hit 100.00%
Pages
Free 8.76k %Total: 15.21
Data 48.44k 84.10 %Drty: 0.08
Misc 394 0.68
Latched 0 0.00
Reads 571.13M 1.6k/s
From file 27.98k 0.1/s 0.00
Ahead Rnd 3 0.0/s
Ahead Sql 364 0.0/s
Writes 5.29M 14.8/s
Flushes 2.02M 5.6/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 70 0.0/s
Current 0
Time acquiring
Total 6796 ms
Average 97 ms
Max 583 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 28.86k 0.1/s
Writes 2.49M 6.9/s
fsync 681.08k 1.9/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 303 0.0/s
Read 48.14k 0.1/s
Written 2.02M 5.6/s
Rows
Deleted 91 0.0/s
Inserted 2.15k 0.0/s
Read 2.26G 6.3k/s
Updated 472.54k 1.3/s