Announcement

Announcement Module
Collapse
No announcement yet.

Questions about mysqlreport output

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

  • Questions about mysqlreport output

    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
Working...
X