I had a couple questions about the output of mysqlreport. I have some very active web applications and the database server is doing 2k questions/second. 2 questions I have are the number of connections/second is pretty high, and also subsequently the number of change_db _COM statements are high. I’m wondering if I should be looking into using mysql_pconnect?
MySQL 5.0.22-log uptime 4 2:51:24 Wed May 28 19:48:20 2008
__ Key ____________________________________________________________ _____
Buffer used 2.74M of 8.00M %Used: 34.19
Current 1.56M %Usage: 19.52
Write hit 99.02%
Read hit 99.67%
__ Questions ___________________________________________________________
Total 701.51M 2.0k/s
QC Hits 330.94M 929.9/s %Total: 47.18
DMS 149.25M 419.4/s 21.28
Com_ 114.55M 321.9/s 16.33
COM_QUIT 107.29M 301.5/s 15.29
-Unknown 528.42k 1.5/s 0.08
Slow 1 s 76.52k 0.2/s 0.01 %DMS: 0.05 Log: ON
DMS 149.25M 419.4/s 21.28
SELECT 106.10M 298.1/s 15.12 71.09
INSERT 26.93M 75.7/s 3.84 18.04
UPDATE 16.17M 45.4/s 2.30 10.83
DELETE 56.73k 0.2/s 0.01 0.04
REPLACE 0 0/s 0.00 0.00
Com_ 114.55M 321.9/s 16.33
change_db 107.28M 301.5/s 15.29
set_option 6.09M 17.1/s 0.87
admin_comma 528.64k 1.5/s 0.08
__ SELECT and Sort _____________________________________________________
Scan 2.17M 6.1/s %SELECT: 2.05
Range 9.99M 28.1/s 9.41
Full join 697 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 80 0.0/s 0.00
Sort scan 2.10M 5.9/s
Sort range 12.14M 34.1/s
Sort mrg pass 5.94k 0.0/s
__ Query Cache _________________________________________________________
Memory usage 2.29M of 7.63M %Used: 30.03
Block Fragmnt 26.10%
Hits 330.94M 929.9/s
Inserts 101.44M 285.0/s
Insrt:Prune 205.92:1 283.7/s
Hit:Insert 3.26:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 171.19M 481.0/s
__ Tables ____________________________________________________________ __
Open 1024 of 1024 %Cache: 100.00
Opened 42.41k 0.1/s
__ Connections _________________________________________________________
Max used 501 of 500 %Max: 100.20
Total 107.29M 301.5/s
__ Created Temp ________________________________________________________
Disk table 3.08k 0.0/s
Table 10.90M 30.6/s Size: 32.0M
File 11.89k 0.0/s
__ Threads ____________________________________________________________ _
Running 3 of 21
Cached 113 of 128 %Hit: 99.85
Created 165.30k 0.5/s
Slow 0 0/s
__ Aborted ____________________________________________________________ _
Clients 64 0.0/s
Connects 8.36k 0.0/s
__ Bytes ____________________________________________________________ ___
Sent 104.97G 295.0k/s
Received 66.63G 187.2k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 4.00G of 4.00G %Used: 100.00
Read hit 99.88%
Pages
Free 0 %Total: 0.00
Data 225.48k 86.01 %Drty: 7.03
Misc 36666 13.99
Latched 0 0.00
Reads 21.48G 60.3k/s
From file 26.38M 74.1/s 0.12
Ahead Rnd 999896 2.8/s
Ahead Sql 642942 1.8/s
Writes 262.64M 738.0/s
Flushes 5.65M 15.9/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 7427 0.0/s
Current 0
Time acquiring
Total 194305 ms
Average 26 ms
Max 1840 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 34.82M 97.8/s
Writes 42.10M 118.3/s
fsync 591.00k 1.7/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 198.44k 0.6/s
Read 55.34M 155.5/s
Written 5.65M 15.9/s
Rows
Deleted 55.28k 0.2/s
Inserted 24.95M 70.1/s
Read 31.55G 88.7k/s
Updated 13.94M 39.2/s