MySQLReport分析报告一

来源：互联网发布：西安欧亚学院网络编辑：程序博客网时间：2024/06/05 00:29
OS：windows2003 配置：8G内存，4核处理器
__ Key _________________________________________________________________Buffer used    27.67M of 155.00M  %Used:  17.85  Current      20.01M            %Usage:  12.91Write hit     100.00%Read hit      100.00%__ Questions ___________________________________________________________Total           8.62M   116.0/s  DMS           8.14M   109.6/s  %Total:  94.44  QC Hits     419.13k     5.6/s            4.86  Com_         60.99k     0.8/s            0.71  -Unknown      2.27k     0.0/s            0.03  COM_QUIT      1.30k     0.0/s            0.02Slow 5 s          195     0.0/s            0.00  %DMS:   0.00  Log:  ONDMS             8.14M   109.6/s           94.44  SELECT        7.13M    95.9/s           82.69         87.55  UPDATE      549.25k     7.4/s            6.37          6.75  INSERT      437.39k     5.9/s            5.07          5.37  DELETE       26.73k     0.4/s            0.31          0.33  REPLACE           0       0/s            0.00          0.00Com_           60.99k     0.8/s            0.71  show_fields  46.88k     0.6/s            0.54  show_create   6.11k     0.1/s            0.07  set_option    3.54k     0.0/s            0.04__ SELECT and Sort _____________________________________________________Scan           55.08k     0.7/s %SELECT:   0.77Range          18.54k     0.2/s            0.26Full join           1     0.0/s            0.00Range check         0       0/s            0.00Full rng join       0       0/s            0.00Sort scan       1.02k     0.0/sSort range         23     0.0/sSort mrg pass     443     0.0/s__ Query Cache _________________________________________________________Memory usage    1.71M of  99.00M  %Used:   1.73Block Fragmnt  18.22%Hits          419.13k     5.6/sInserts         1.42M    19.2/sInsrt:Prune   1.42M:1    19.2/sHit:Insert     0.29:1__ Table Locks _________________________________________________________Waited             44     0.0/s  %Total:   0.00Immediate       2.44M    32.9/s__ Tables ______________________________________________________________Open               38 of  320    %Cache:  11.88Opened          6.69k     0.1/s__ Connections _________________________________________________________Max used           29 of 1500      %Max:   1.93Total           1.46k     0.0/s__ Created Temp ________________________________________________________Disk table     48.19k     0.6/sTable          53.23k     0.7/s    Size: 103.0MFile              473     0.0/s__ Threads _____________________________________________________________Running             2 of   25Cached              0 of    8      %Hit:  97.06Created            43     0.0/sSlow                0       0/s__ Aborted _____________________________________________________________Clients           321     0.0/sConnects            5     0.0/s__ Bytes _______________________________________________________________Sent           12.05G  162.2k/sReceived      450.03M    6.1k/s__ InnoDB Buffer Pool __________________________________________________Usage           1.00G of   1.00G  %Used: 100.00Read hit       99.92%Pages  Free              1            %Total:   0.00  Data         63.95k                     97.58 %Drty:  22.81  Misc           1583                      2.42  Latched                                  0.00Reads         835.19M   11.2k/s  From file   657.78k     8.9/s            0.08  Ahead Rnd                 0/s  Ahead Sql                 0/sWrites         21.16M   284.8/sFlushes         1.10M    14.8/sWait Free           0       0/s__ InnoDB Lock _________________________________________________________Waits               9     0.0/sCurrent             0Time acquiring  Total       2346968 ms  Average      260774 ms  Max         1005125 ms__ InnoDB Data, Pages, Rows ____________________________________________Data  Reads         1.32M    17.8/s  Writes        1.58M    21.2/s  fsync        49.89k     0.7/s  Pending    Reads           0    Writes          0    fsync           0Pages  Created      33.66k     0.5/s  Read          1.32M    17.8/s  Written     550.68k     7.4/sRows  Deleted     437.44k     5.9/s  Inserted      3.01M    40.5/s  Read        864.12M   11.6k/s  Updated     829.91k    11.2/s