【openGauss服务器端工具的使用】

发布时间:2024年01月04日

【openGauss服务器端工具的使用】

  1. gs_checkperf

    openGauss 不仅提供了gs_checkperf工具来帮助用户了解openGauss的负载情况。

    • 使用数据库安装用户登录服务器,执行如下命令进行查看数据库性能:
      简要信息展示:
      [omm@opengauss03 ~]$ gs_checkperf  -i PMK
      Cluster statistics information:
          Host CPU busy time ratio                     :    1.70       %  
          MPPDB CPU time % in busy time                :    91.66      %
          Shared Buffer Hit ratio                      :    99.80      %
          In-memory sort ratio                         :    0
          Physical Reads                               :    431
          Physical Writes                              :    455
          DB size                                      :    34         MB
          Total Physical writes                        :    455
          Active SQL count                             :    4
          Session count                                :    6
      
      
      详细信息展示
      [omm@opengauss03 ~]$ gs_checkperf -i PMK --detail
      Cluster statistics information:
      Host CPU usage rate:
          Host total CPU time                          :    33179390.000 Jiffies
          Host CPU busy time                           :    568840.000 Jiffies
          Host CPU iowait time                         :    18830.000  Jiffies
          Host CPU busy time ratio                     :    1.71       %
          Host CPU iowait time ratio                   :    .06        %
      MPPDB CPU usage rate:
          MPPDB CPU time % in busy time                :    89.78      %
          MPPDB CPU time % in total time               :    1.54       %
      Shared buffer hit rate:
          Shared Buffer Reads                          :    451
          Shared Buffer Hits                           :    178772
          Shared Buffer Hit ratio                      :    99.75      %
      In memory sort rate:
          In-memory sort count                         :    0
          In-disk sort count                           :    0
          In-memory sort ratio                         :    0
      I/O usage:
          Number of files                              :    97
          Physical Reads                               :    421
          Physical Writes                              :    320
          Read Time                                    :    6167       ms
          Write Time                                   :    3547       ms
      Disk usage:
          DB size                                      :    34         MB
          Total Physical writes                        :    320
          Average Physical write                       :    90217.08
          Maximum Physical write                       :    320
      Activity statistics:
          Active SQL count                             :    4
          Session count                                :    6
      Node statistics information:
      dn_6001:
          MPPDB CPU Time                               :    510710     Jiffies
          Host CPU Busy Time                           :    568840     Jiffies
          Host CPU Total Time                          :    33179390   Jiffies
          MPPDB CPU Time % in Busy Time                :    89.78      %
          MPPDB CPU Time % in Total Time               :    1.54       %
          Physical memory                              :    2606247936 Bytes
          DB Memory usage                              :    4896587776 Bytes
          Shared buffer size                           :    268435456  Bytes
          Shared buffer hit ratio                      :    99.75      %
          Sorts in memory                              :    0
          Sorts in disk                                :    0
          In-memory sort ratio                         :    0
          Number of files                              :    97
          Physical Reads                               :    421
          Physical Writes                              :    320
          Read Time                                    :    6167
          Write Time                                   :    3547
      Session statistics information(Top 10):
      Session CPU statistics:
      1 dn_6001-postgres-omm:
          Session CPU time                             :    3
          Database CPU time                            :    510760
          Session CPU time %                           :    0.00       %
      2 dn_6001-postgres-omm:
          Session CPU time                             :    0
          Database CPU time                            :    510760
          Session CPU time %                           :    0.00       %
      3 dn_6001-postgres-omm:
          Session CPU time                             :    0
          Database CPU time                            :    510760
          Session CPU time %                           :    0.00       %
      4 dn_6001-postgres-omm:
          Session CPU time                             :    0
          Database CPU time                            :    510760
          Session CPU time %                           :    0.00       %
      
      Session Memory statistics:
      1 dn_6001-postgres-omm:
          Buffer Reads                                 :    1607
          Shared Buffer Hit ratio                      :    93.05
          In Memory sorts                              :    0
          In Disk sorts                                :    0
          In Memory sorts ratio                        :    0
          Total Memory Size                            :    6566592
          Used Memory Size                             :    5338376
      2 dn_6001-postgres-omm:
          Buffer Reads                                 :    283
          Shared Buffer Hit ratio                      :    100.00
          In Memory sorts                              :    0
          In Disk sorts                                :    0
          In Memory sorts ratio                        :    0
          Total Memory Size                            :    6542016
          Used Memory Size                             :    5281600
      3 dn_6001-postgres-omm:
          Buffer Reads                                 :    39
          Shared Buffer Hit ratio                      :    100.00
          In Memory sorts                              :    0
          In Disk sorts                                :    0
          In Memory sorts ratio                        :    0
          Total Memory Size                            :    5518016
          Used Memory Size                             :    5055232
      4 dn_6001-postgres-omm:
          Buffer Reads                                 :    1023
          Shared Buffer Hit ratio                      :    100.00
          In Memory sorts                              :    1
          In Disk sorts                                :    0
          In Memory sorts ratio                        :    100.00
          Total Memory Size                            :    11617840
          Used Memory Size                             :    9327632
      
      Session IO statistics:
      1 dn_6001-postgres-omm:
          Physical Reads                               :    120
          Read Time                                    :    2383
      2 dn_6001-postgres-omm:
          Physical Reads                               :    0
          Read Time                                    :    0
      3 dn_6001-postgres-omm:
          Physical Reads                               :    0
          Read Time                                    :    0
      4 dn_6001-postgres-omm:
          Physical Reads                               :    0
          Read Time                                    :    0
      
      
  2. gs_collector

    数据库运行时,某些操作在执行过程中可能会出现错误,数据库依然能够运行。但是此时数据库中的数据可能已经发生不一致的情况。建议检查openGauss运行日志,及时发现隐患。
    当openGauss发生故障时,使用 gs_collector 此工具收集OS信息、日志信息以及配置文件等信息,来定位问题。

    • 设置收集配置文件,新建collector.json文件,添加如下内容:

      {
          "Collect": [
              {
                  "Content": "RunTimeInfo,HardWareInfo",
                  "Count": "1",
                  "Interval": "0",
                  "TypeName": "System"
              },
              {
                  "Content": "Coordinator,DataNode,Gtm,ClusterManager",
                  "Count": "1",
                  "Interval": "0",
                  "TypeName": "Log"
              },
              {
                  "Content": "pg_locks,pg_stat_activity,pg_thread_wait_status",
                  "Count": "1",
                  "Interval": "0",
                  "TypeName": "Database"
              },
              {
                  "Content": "Coordinator,DataNode,Gtm",
                  "Count": "1",
                  "Interval": "0",
                  "TypeName": "Config"
              }
          ]
      }
      
    • 执行如下命令进行信息收集:

      gs_collector --begin-time="20240103 07:00" --end-time="20240103 22:30" -C /home/omm/collector.json
      

      结果如下:

      Successfully parsed the configuration file.
      create Dir.
      Successfully create dir.
      do system check interval 0 : count 1
      Collecting OS information.
      The cmd is source /home/omm/.bashrc; python3 ‘/opt/install/om/script/local/LocalCollect.py’ -t system_check -U omm -l /opt/install/log/omm/omm/om/gs_local.log -C ‘{#Content#: #ps,ioStat,netFlow,spaceUsage,cpuInfo,memInfo,disk,#, #Count#: #1#, #Interval#: #0#, #TypeName#: #System#}’
      Failed to collect OS information.
      do database check interval 0 : count 1
      Collecting catalog statistics.
      Successfully collected catalog statistics.
      do log check interval 0 : count 1
      Collecting Log files.
      Successfully collected Log files.
      do Config check 0:1
      Collecting Config files.
      Successfully collected Config files.
      Collecting files.
      Successfully collected files.
      All results are stored in /opt/install/tmp/collector_20240103_214254.tar.gz.

      详细可查看结果文件,比如:

      [omm@opengauss03 ~]$ tar -zvxf /opt/install/tmp/collector_20240103_214254.tar.gz -C ./
      collector_20240103_214254/
      collector_20240103_214254/Detail.log
      collector_20240103_214254/opengauss03.tar.gz
      collector_20240103_214254/Summary.log
      [omm@opengauss03 ~]$ ll
      total 8.0K
      drwx------. 2 omm dbgrp 4.0K Jan 3 21:43 collector_20240103_214254
      -rw-------. 1 omm dbgrp 703 Jan 3 21:41 collector.json
      [omm@opengauss03 ~]$ cd collector_20240103_214254/
      [omm@opengauss03 collector_20240103_214254]$ ll
      total 84K
      -rw-------. 1 omm dbgrp 2.3K Jan 3 21:43 Detail.log
      -rw-------. 1 omm dbgrp 76K Jan 3 21:43 opengauss03.tar.gz
      -rw-------. 1 omm dbgrp 1.1K Jan 3 21:43 Summary.log
      [omm@opengauss03 collector_20240103_214254]$ cat Summary.log
      在这里插入图片描述

  3. gs_check

    gs_check改进增强,统一化当前系统中存在的各种检查工具,例如gs_check、gs_checkos等,帮助用户在openGauss运行过程中,全量的检查openGauss运行环境、操作系统环境、网络环境及数据库执行环境,也有助于在openGauss重大操作之前对各类环境进行全面检查,有效保证操作执行成功。具体可参考官网:gs_check

    • 示例如下:检查CPU\MTP\PING
      gs_check -i CheckCPU,CheckMTU,CheckPing
      
      结果如下:
      在这里插入图片描述
文章来源:https://blog.csdn.net/sujiangming/article/details/135374351
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。