Announcement

Announcement Module
Collapse
No announcement yet.

mysqlreport, com_change_db value

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysqlreport, com_change_db value

    hi,

    this is the result of mysqlreport (mysql 5 + php5 [PEARB] )

    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

  • #2
    up! (

    Comment


    • #3
      it are your queries, obviously

      Comment

      Working...
      X