# mysqlreport, com\_change\_db value

**URL:** <https://forums.percona.com/t/mysqlreport-com-change-db-value/1296>\
**Category:** Other MySQL® Questions\
**Created:** [November 23, 2009, 12:41pm UTC](https://forums.percona.com/t/mysqlreport-com-change-db-value/1296 "2009-11-23T12:41:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pepejose](https://avatars.discourse-cdn.com/v4/letter/p/58f4c7/32.png) [@pepejose](https://forums.percona.com/u/pepejose)\
**Post date:** [November 23, 2009, 12:41pm UTC](https://forums.percona.com/t/mysqlreport-com-change-db-value/1296/1 "2009-11-23T12:41:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pepejose](https://avatars.discourse-cdn.com/v4/letter/p/58f4c7/32.png) [@pepejose](https://forums.percona.com/u/pepejose)\
**Post date:** [November 27, 2009, 4:28am UTC](https://forums.percona.com/t/mysqlreport-com-change-db-value/1296/2 "2009-11-27T04:28:08Z")

</div>

up! (

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [November 27, 2009, 12:36pm UTC](https://forums.percona.com/t/mysqlreport-com-change-db-value/1296/3 "2009-11-27T12:36:09Z")

</div>

it are your queries, obviously