mysqlreport参数分析

最新推荐文章于 2024-09-24 14:20:23 发布

原创最新推荐文章于 2024-09-24 14:20:23 发布 · 150 阅读

0 ·

CC 4.0 BY-SA版权

【Java】专栏收录该内容

1 篇文章

订阅专栏

本文详细展示了MySQL数据库的性能调优过程，包括缓存使用情况、查询缓存效率、锁等待时间、临时表使用及线程运行状态等关键指标分析，并针对存在的问题提出了解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

请大家帮忙看下，我优化的是否还存在较大的问题。




__ Key _________________________________________________________________
Buffer used    12.31M of 155.00M  %Used:   7.94
  Current      20.01M            %Usage:  12.91
Write hit     100.00%
Read hit      100.00%

__ Questions ___________________________________________________________
Total           8.81M    77.5/s
  -Unknown     38.46M   338.7/s  %Total: 436.80
  Com_         36.28M   319.5/s          412.00
  DMS          10.66M    93.9/s          121.07
  QC Hits     325.22k     2.9/s            3.69
  COM_QUIT      3.92k     0.0/s            0.04
Slow 5 s          629     0.0/s            0.01  %DMS:   0.01  Log:  ON
DMS            10.66M    93.9/s          121.07
  SELECT        6.05M    53.3/s           68.72         56.76
  INSERT        4.06M    35.8/s           46.16         38.13
  UPDATE      539.15k     4.7/s            6.12          5.06
  DELETE        5.54k     0.0/s            0.06          0.05
  REPLACE           0       0/s            0.00          0.00
Com_           36.28M   319.5/s          412.00
  set_option   35.81M   315.4/s          406.67
  commit      334.20k     2.9/s            3.80
  show_fields  89.78k     0.8/s            1.02

__ SELECT and Sort _____________________________________________________
Scan          148.09k     1.3/s %SELECT:   2.45
Range          13.47k     0.1/s            0.22
Full join          38     0.0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan       5.82k     0.1/s
Sort range        188     0.0/s
Sort mrg pass   2.07k     0.0/s

__ Query Cache _________________________________________________________
Memory usage    3.23M of  99.00M  %Used:   3.26
Block Fragmnt   9.98%
Hits          325.22k     2.9/s
Inserts       948.09k     8.3/s
Insrt:Prune 948.09k:1     8.3/s
Hit:Insert     0.34:1

__ Table Locks _________________________________________________________
Waited             34     0.0/s  %Total:   0.00
Immediate       2.22M    19.6/s

__ Tables ______________________________________________________________
Open               36 of  320    %Cache:  11.25
Opened         11.40k     0.1/s

__ Connections _________________________________________________________
Max used           52 of 1500      %Max:   3.47
Total           4.48k     0.0/s

__ Created Temp ________________________________________________________
Disk table     91.95k     0.8/s
Table         124.94k     1.1/s    Size: 103.0M
File            2.22k     0.0/s

__ Threads _____________________________________________________________
Running            11 of   36
Cached              1 of    8      %Hit:  97.41
Created           116     0.0/s
Slow                0       0/s

__ Aborted _____________________________________________________________
Clients         1.12k     0.0/s
Connects            0       0/s

__ Bytes _______________________________________________________________
Sent           13.75G  121.1k/s
Received      533.48M    4.7k/s

__ InnoDB Buffer Pool __________________________________________________
Usage           1.00G of   1.00G  %Used: 100.00
Read hit       99.32%
Pages
  Free              0            %Total:   0.00
  Data         62.82k                     95.86 %Drty:   0.98
  Misc           2716                      4.14
  Latched                                  0.00
Reads         590.09M    5.2k/s
  From file     4.03M    35.5/s            0.68
  Ahead Rnd                 0/s
  Ahead Sql                 0/s
Writes        167.67M    1.5k/s
Flushes         3.61M    31.8/s
Wait Free           0       0/s

__ InnoDB Lock _________________________________________________________
Waits             391     0.0/s
Current             7
Time acquiring
  Total      86948826 ms
  Average      222375 ms
  Max         4282062 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads         5.06M    44.6/s
  Writes        3.17M    27.9/s
  fsync       122.56k     1.1/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created     174.77k     1.5/s
  Read          5.06M    44.6/s
  Written       1.80M    15.9/s

Rows
  Deleted       7.42M    65.3/s
  Inserted     21.75M   191.5/s
  Read        575.04M    5.1k/s
  Updated     583.08k     5.1/s