Key _________________________________________________________________
Buffer used    12.54M of 155.00M  %Used:   8.09
  Current      20.01M            %Usage:  12.91
Write hit     100.00%
Read hit      100.00%__ Questions ___________________________________________________________
Total          73.58M   142.6/s
  DMS          65.51M   127.0/s  %Total:  89.04
  Com_          7.22M    14.0/s            9.82
  QC Hits     853.65k     1.7/s            1.16
  -Unknown     20.96k     0.0/s            0.03
  COM_QUIT      8.87k     0.0/s            0.01
Slow 5 s          224     0.0/s            0.00  %DMS:   0.00  Log:  ON
DMS            65.51M   127.0/s           89.04
  SELECT       57.59M   111.6/s           78.27         87.91
  UPDATE        4.41M     8.6/s            6.00          6.74
  INSERT        3.40M     6.6/s            4.63          5.20
  DELETE      102.66k     0.2/s            0.14          0.16
  REPLACE           0       0/s            0.00          0.00
Com_            7.22M    14.0/s            9.82
  show_warnin   6.96M    13.5/s            9.46
  show_fields 187.49k     0.4/s            0.25
  set_option   26.98k     0.1/s            0.04__ SELECT and Sort _____________________________________________________
Scan          300.81k     0.6/s %SELECT:   0.52
Range         275.20k     0.5/s            0.48
Full join          13     0.0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan      18.99k     0.0/s
Sort range         61     0.0/s
Sort mrg pass  13.61k     0.0/s__ Query Cache _________________________________________________________
Memory usage    6.90M of  99.00M  %Used:   6.97
Block Fragmnt   4.64%
Hits          853.65k     1.7/s
Inserts        13.34M    25.9/s
Insrt:Prune  13.34M:1    25.9/s
Hit:Insert     0.06:1__ Table Locks _________________________________________________________
Waited            297     0.0/s  %Total:   0.00
Immediate      21.31M    41.3/s__ Tables ______________________________________________________________
Open               43 of  320    %Cache:  13.44
Opened         24.46k     0.0/s__ Connections _________________________________________________________
Max used           28 of 1500      %Max:   1.87
Total          10.15k     0.0/s__ Created Temp ________________________________________________________
Disk table    190.99k     0.4/s
Table         214.95k     0.4/s    Size: 103.0M
File           26.51k     0.1/s__ Threads _____________________________________________________________
Running             3 of   21
Cached              4 of    8      %Hit:  99.14
Created            87     0.0/s
Slow                0       0/s__ Aborted _____________________________________________________________
Clients         2.57k     0.0/s
Connects            6     0.0/s__ Bytes _______________________________________________________________
Sent           91.09G  176.6k/s
Received        3.60G    7.0k/s__ InnoDB Buffer Pool __________________________________________________
Usage           1.00G of   1.00G  %Used: 100.00
Read hit       99.71%
Pages
  Free              1            %Total:   0.00
  Data         62.00k                     94.60 %Drty:  68.93
  Misc           3539                      5.40
  Latched                                  0.00
Reads           1.36G    2.6k/s
  From file     3.89M     7.5/s            0.29
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        114.50M   221.9/s
Flushes         7.59M    14.7/s
Wait Free           0       0/s__ InnoDB Lock _________________________________________________________
Waits             169     0.0/s
Current             0
Time acquiring
  Total      22000953 ms
  Average      130183 ms
  Max         2592093 ms__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         8.83M    17.1/s
  Writes       11.93M    23.1/s
  fsync       373.36k     0.7/s
  Pending
    Reads           0
    Writes          0
    fsync           1Pages
  Created     223.55k     0.4/s
  Read          8.83M    17.1/s
  Written       3.80M     7.4/sRows
  Deleted       3.20M     6.2/s
  Inserted     13.42M    26.0/s
  Read        849.74M    1.6k/s
  Updated       4.57M     8.9/s以上是小弟优化mysql的报告。希望大家给出建议。那个地方不够合理。CPU 650 I5,4g内存,windows Server 2003