MySQLReport分析报告一

最新推荐文章于 2021-03-17 22:43:51 发布

十年彩虹

最新推荐文章于 2021-03-17 22:43:51 发布

阅读量941

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/k_scott/article/details/8641053

版权

MySQL 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

OS：windows2003 配置：8G内存，4核处理器

__ Key _________________________________________________________________
Buffer used    27.67M of 155.00M  %Used:  17.85
  Current      20.01M            %Usage:  12.91
Write 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.02
Slow 5 s          195     0.0/s            0.00  %DMS:   0.00  Log:  ON
DMS             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.00
Com_           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.77
Range          18.54k     0.2/s            0.26
Full join           1     0.0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       1.02k     0.0/s
Sort range         23     0.0/s
Sort mrg pass     443     0.0/s

__ Query Cache _________________________________________________________
Memory usage    1.71M of  99.00M  %Used:   1.73
Block Fragmnt  18.22%
Hits          419.13k     5.6/s
Inserts         1.42M    19.2/s
Insrt:Prune   1.42M:1    19.2/s
Hit:Insert     0.29:1

__ Table Locks _________________________________________________________
Waited             44     0.0/s  %Total:   0.00
Immediate       2.44M    32.9/s

__ Tables ______________________________________________________________
Open               38 of  320    %Cache:  11.88
Opened          6.69k     0.1/s

__ Connections _________________________________________________________
Max used           29 of 1500      %Max:   1.93
Total           1.46k     0.0/s

__ Created Temp ________________________________________________________
Disk table     48.19k     0.6/s
Table          53.23k     0.7/s    Size: 103.0M
File              473     0.0/s

__ Threads _____________________________________________________________
Running             2 of   25
Cached              0 of    8      %Hit:  97.06
Created            43     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients           321     0.0/s
Connects            5     0.0/s

__ Bytes _______________________________________________________________
Sent           12.05G  162.2k/s
Received      450.03M    6.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage           1.00G of   1.00G  %Used: 100.00
Read hit       99.92%
Pages
  Free              1            %Total:   0.00
  Data         63.95k                     97.58 %Drty:  22.81
  Misc           1583                      2.42
  Latched                                  0.00
Reads         835.19M   11.2k/s
  From file   657.78k     8.9/s            0.08
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes         21.16M   284.8/s
Flushes         1.10M    14.8/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits               9     0.0/s
Current             0
Time 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           0

Pages
  Created      33.66k     0.5/s
  Read          1.32M    17.8/s
  Written     550.68k     7.4/s

Rows
  Deleted     437.44k     5.9/s
  Inserted      3.01M    40.5/s
  Read        864.12M   11.6k/s
  Updated     829.91k    11.2/s