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

发布时间：2024年01月04日

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

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

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
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
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若内容造成侵权/违法违规/事实不符，请联系我的编程经验分享网邮箱：chenni525@qq.com进行投诉反馈，一经查实，立即删除！