DBdoctor介绍

DBdoctor是一款内核级数据库性能诊断软件，致力于解决数据库的一切性能问题。 就像对数据库做全身CT，帮助您一分钟内找到数据库性能问题，实现数据库性能诊断百倍提效。 针对数据库性诊断门槛高、耗时长的问题，DBdoctor提供了快速易用的解决方案， 基于海量数据实时分析技术，深入到数据库内核，提供精准的诊断分析和优化建议。

DBdoctor特点

深度分析

深入数据库内核的全方面分析

· 深入到数据库内核锁管理全过程

· 精准提示死锁和锁等待根因

· 可视化展示死锁、锁等待、长事务

便捷易用

可视化/极简交互、极致用户体验

· 一屏展示资源 - 负载SQL，轻松定位性能根因

· 哪里不会点哪里 - 点击异常指标自动展示专家案例知识库内容示，帮助DBA更轻松的开展分析

精确诊断

精确到SQL级的性能洞察

· 自研DRA算法引擎，精准提示根因SQL及等待事件

· 对SQL按照资源瓶颈自动分类，快速提示资源卡点

· 按访问来源进行SQL归类，快速找到问题客户端

轻量接入

无需改动现有系统

· 五分钟内完成一键部署，对数据库实例性能影响接近于零

· 支持对私有云、公有云上的存量数据库实例无感纳管

下载

安装包下载地址/部署文档：https://www.hisensecloud.com/h-col-126.html

单击免费下载会弹出如下界面：

点击立即下载，下载后将DBdoctorV3.1.2_20240417V5.tar.gz安装介质上传至/opt目录下，该安装介质大小约为1.49G。

依赖包安装

[root@top132:/opt]$ yum install -y kernel-devel*

若不安装该依赖包，在安装DBdoctor过程中会提示如下警告：

2024-04-24 08:44:12.000782846 [WARN] [dbd]: kernel-devel-3.10.0-1160.el7.x86_64 is not installed, can not use agent special feature,you can try yum install kernel-devel-3.10.0-1160.el7.x86_64
2024-04-24 00:47:02.812803135 [WARN] [service.sh]: The kernel-devel is not installed,the agent can not use special function!
2024-04-24 08:47:07.958191396 [WARN] [dbd]: KERNEL or  EBPF is not support, can't open lock button!

若未配置yum源，则下载并安装

上传rpm包并安装

rpm包下载地址：http://rpmfind.net/linux/centos/7.9.2009/os/x86_64/Packages/kernel-devel-3.10.0-1160.el7.x86_64.rpm

rpm -ivh kernel-devel-3.10.0-1160.el7.x86_64.rpm

安装DBdoctor

安装过程

资源规格：4c8g（推荐），本文档服务器配置：Centos 7.9 x86_64 4c16g

零依赖一分钟快速安装

--解压安装包并执行一条命令即可部署完成  -I, --install 安装
cd /opt
tar -xvf DBdoctorV3.1.2_20240417V5.tar.gz
cd /opt/dbdoctor-3.1.2
./dbd -I   

详细过程如下：

[root@top132:/opt/dbdoctor-3.1.2]$ ./dbd -I
2024-04-24 08:44:09.947605523 [INFO] [dbd]: Command Tool Version 3.1.2.0,Handler Command: install
2024-04-24 08:44:11.399697144 [INFO] [dbd]: current_path available_space  is 12GB, is valid, to do next~
2024-04-24 08:44:11.409337451 [INFO] [dbd]: stand-alone mode,all service will install in one host
2024-04-24 08:44:12.000782846 [WARN] [dbd]: kernel-devel-3.10.0-1160.el7.x86_64 is not installed, can not use agent special feature,you can try yum install kernel-devel-3.10.0-1160.el7.x86_64
2024-04-24 08:44:12.008108321 [INFO] [dbd]: HOST_IP: 192.168.3.132
2024-04-24 08:44:12.056254172 [INFO] [dbd]: AGENT port: 22888
2024-04-24 08:44:12.067946697 [INFO] [dbd]: SAMPLE_PORT port: 8080
2024-04-24 08:44:12.080233007 [INFO] [dbd]: PI_PORT port: 13000
2024-04-24 08:44:12.109460459 [INFO] [dbd]: ALGO_PORT port: 8999
2024-04-24 08:44:12.120870406 [INFO] [dbd]: COST_PORT port: 3606
2024-04-24 08:44:12.132047242 [INFO] [dbd]: COST57_PORT port: 3706
2024-04-24 08:44:12.143295449 [INFO] [dbd]: KAFKA_NODE_PORT port: 9092
2024-04-24 08:44:12.154567672 [INFO] [dbd]: KAFKA_CONTROLLER_PORT port: 19093
2024-04-24 08:44:12.165862091 [INFO] [dbd]: port 3306 is already use
2024-04-24 08:44:12.175076988 [INFO] [dbd]: MYSQL_NODE_PORT port: 3307
2024-04-24 08:44:12.592654824 [INFO] [dbd]: creating agent package, wait a moment......
2024-04-24 08:46:21.091532408 [INFO] [dbd]:
2024-04-24 08:46:21.098480323 [INFO] [dbd]:   ____   ____   ____    ___    ____  _____  ___   ____
2024-04-24 08:46:21.103917709 [INFO] [dbd]:  |  _ \ | __ ) |  _ \  / _ \  / ___||_   _|/ _ \ |  _ \
2024-04-24 08:46:21.109575632 [INFO] [dbd]:  | | | ||  _ \ | | | || | | || |      | | | | | || |_) |
2024-04-24 08:46:21.115339995 [INFO] [dbd]:  | |_| || |_) || |_| || |_| || |___   | | | |_| ||  _ <
2024-04-24 08:46:21.120722143 [INFO] [dbd]:  |____/ |____/ |____/  \___/  \____|  |_|  \___/ |_| \_\
2024-04-24 08:46:21.126453989 [INFO] [dbd]:
2024-04-24 08:46:21.131681906 [INFO] [dbd]: start stand-alone mode service
2024-04-24 00:46:21.151151644 [INFO] [service.sh]: check mysql status 1 times
2024-04-24 00:46:23.496366781 [INFO] [service.sh]: check mysql status 2 times
2024-04-24 00:46:25.583573245 [INFO] [service.sh]: check mysql status 3 times
2024-04-24 00:46:25.599917936 [INFO] [service.sh]: mysql is running
2024-04-24 00:46:25.622404380 [INFO] [service.sh]: check kafka status 1 times
2024-04-24 00:46:25.656131185 [INFO] [service.sh]: kafka is running
2024-04-24 00:46:25.680177779 [INFO] [service.sh]: check dra-algo-ml status 1 times
2024-04-24 00:46:27.699249957 [INFO] [service.sh]: check dra-algo-ml status 2 times
2024-04-24 00:46:29.719617417 [INFO] [service.sh]: check dra-algo-ml status 3 times
2024-04-24 00:46:31.738783011 [INFO] [service.sh]: check dra-algo-ml status 4 times
2024-04-24 00:46:33.758176041 [INFO] [service.sh]: check dra-algo-ml status 5 times
2024-04-24 00:46:35.777383883 [INFO] [service.sh]: check dra-algo-ml status 6 times
2024-04-24 00:46:35.795925694 [INFO] [service.sh]: dra-algo-ml is running
2024-04-24 00:46:35.870326077 [INFO] [service.sh]: check dra-pi status 1 times
2024-04-24 00:46:37.888886317 [INFO] [service.sh]: check dra-pi status 2 times
2024-04-24 00:46:39.906131863 [INFO] [service.sh]: check dra-pi status 3 times
2024-04-24 00:46:41.925409759 [INFO] [service.sh]: check dra-pi status 4 times
2024-04-24 00:46:43.976663635 [INFO] [service.sh]: check dra-pi status 5 times
2024-04-24 00:46:43.993399243 [INFO] [service.sh]: dra-pi is running
2024-04-24 00:46:44.017785023 [INFO] [service.sh]: check dra-data-sample status 1 times
2024-04-24 00:46:46.036682512 [INFO] [service.sh]: check dra-data-sample status 2 times
2024-04-24 00:46:48.057547008 [INFO] [service.sh]: check dra-data-sample status 3 times
2024-04-24 00:46:50.100037771 [INFO] [service.sh]: check dra-data-sample status 4 times
2024-04-24 00:46:50.127330396 [INFO] [service.sh]: dra-data-sample is running
2024-04-24 00:46:50.405072914 [INFO] [service.sh]: check dra-cost status 1 times
2024-04-24 00:46:52.421712573 [INFO] [service.sh]: check dra-cost status 2 times
2024-04-24 00:46:54.439056498 [INFO] [service.sh]: check dra-cost status 3 times
2024-04-24 00:46:56.456102267 [INFO] [service.sh]: check dra-cost status 4 times
2024-04-24 00:46:58.474301986 [INFO] [service.sh]: check dra-cost status 5 times
2024-04-24 00:46:58.489125333 [INFO] [service.sh]: dra-cost is running
2024-04-24 00:46:58.509169496 [INFO] [service.sh]: check dra-cost57 status 1 times
2024-04-24 00:47:00.537648785 [INFO] [service.sh]: check dra-cost57 status 2 times
2024-04-24 00:47:02.556977730 [INFO] [service.sh]: check dra-cost57 status 3 times
2024-04-24 00:47:02.574815815 [INFO] [service.sh]: dra-cost57 is running
2024-04-24 00:47:02.812803135 [WARN] [service.sh]: The kernel-devel is not installed,the agent can not use special function!
2024-04-24 00:47:02.826370332 [INFO] [service.sh]: check dra-agent status 1 times
2024-04-24 00:47:04.848683686 [INFO] [service.sh]: check dra-agent status 2 times
2024-04-24 00:47:06.869705064 [INFO] [service.sh]: check dra-agent status 3 times
2024-04-24 00:47:06.886068990 [INFO] [service.sh]: dra-agent is running
2024-04-24 08:47:06.901826672 [INFO] [dbd]: agent set cpu limit
2024-04-24 08:47:06.916291790 [INFO] [dbd]: cpu.cfs_quota_us is set to 100000
2024-04-24 08:47:06.935645154 [INFO] [dbd]: agent set memory limit
2024-04-24 08:47:06.942410426 [INFO] [dbd]: memory.limit_in_bytes is set to 2147483648
2024-04-24 08:47:06.949415146 [INFO] [dbd]: memory.memsw.limit_in_bytes is set to 2147483648
2024-04-24 08:47:06.955261195 [INFO] [dbd]: dbd service start complete
2024-04-24 08:47:06.960906192 [INFO] [dbd]: Server Info:
############################################################################
WebSite:  http://192.168.3.132:13000/#/login
DBA User:     tester
DBA Password: Root2023!
If you want to set system config,please use admin user to login in.
Admin User:       admin
Admin Password:   123456
If you changed the default password, please login in with the new password.
############################################################################

mysql: [Warning] Using a password on the command line interface can be insecure.
2024-04-24 08:47:07.479221861 [INFO] [dbd]: add demo instance and open function, wait a moment......
2024-04-24 08:47:07.839449960 [INFO] [dbd]: add demo instance success,begin open functions
2024-04-24 08:47:07.925492290 [INFO] [dbd]: set demo instance managed
2024-04-24 08:47:07.930733089 [INFO] [dbd]: waiting demo instance agent running
2024-04-24 08:47:07.958191396 [WARN] [dbd]: KERNEL or  EBPF is not support, can't open lock button!
2024-04-24 08:47:07.963504292 [INFO] [dbd]: add demo instance complete

登录信息

WebSite: http://192.168.3.132:13000/#/login

DBA User: tester

DBA Password: Root2023!

If you want to set system config,please use admin user to login in.

Admin User: admin

Admin Password: 123456

补充

卸载

--执行卸载命令一键卸载  -U 即--uninstall 卸载
cd /opt/dbdoctor-3.1.2
./dbd -U

--删除目录
[root@top132:/opt/dbdoctor-3.1.2]$ cd ../
[root@top132:/opt]$ rm -rf dbdoctor-3.1.2/

卸载详细过程：

[root@top132:/opt/dbdoctor-3.1.2]$ ./dbd -U
2024-04-24 09:05:40.429490825 [INFO] [dbd]: Command Tool Version 3.1.2.0,Handler Command: uninstall
2024-04-24 09:05:40.456469783 [INFO] [dbd]: stop dbd service, wait a moment......
2024-04-24 09:05:40.580944490 [INFO] [dbd]: stop stand-alone mode service
2024-04-24 09:05:49.373482253 [INFO] [dbd]: dbd service stop complete
2024-04-24 09:05:49.808846476 [INFO] [dbd]: dbd service uninstall complete,you can rm the install_dir /opt/dbdoctor-3.1.2

查看帮助信息

cd /opt/dbdoctor-3.1.2
[root@top132:/opt/dbdoctor-3.1.2]$ ./dbd --help
Usage:
Quick Install:           ./dbd -I
Quick Install With Ip:   ./dbd -I --ip <host ip1> --download_ip <host ip2>. use the command,when host have multiple ip
Quick Ha Install:        ./dbd -I --mode ha --ip <host ip> --mysql <mysql_ip:mysql_port> --mysql_user <mysql_user> --mysql_password <mysql_password> --kafka <kafka_ip:kafka_port>

Command:
-H, --help               print this message
-I, --install            install dbdoctor
    --logs               collect install and runtime logs for analyze problems
    --restart            can with [all] restart all service,or with single component name in [mysql,kafka,dra-pi,dra-data-sample,dra-algo-ml,dra-cost,agent]
    --start              can with [all] start all service,or with single component name in [mysql,kafka,dra-pi,dra-data-sample,dra-algo-ml,dra-cost,agent]
    --status             show component process status
    --stop               can with [all] stop all service,or with single component name in [mysql,kafka,dra-pi,dra-data-sample,dra-algo-ml,dra-cost,agent]
-U, --uninstall          uninstall dbdoctor
    --switch             switch [audit,db,msg]
                           audit: only switch audit db to new mysql or doris, with option --mysql<ip:port> --mysql_user --mysql_password, when switch to doris,also need --http_port option
                           db   : switch all db to new mysql,  with option --mysql<ip:port> --mysql_user --mysql_password
                           msg  : switch all msg to new kafka, with option --kafka<ip:port>

Option:
    --ip                 host ip
    --download_ip        download ip,used for download agent from server when the host have multiple ip
-K  --kafka              provide kafka address,format like <kafka_ip>:<kafka_port>
-M, --mode               mode,stand-alone or ha
    --mysql              provide mysql protocol address,format like <mysql_ip>:<mysql_port>
    --mysql_user         mysql protocol user
    --mysql_password     mysql protocol password
    --http_port          when switch audit db to doris,provide doris http port

疑问

问题描述：已安装依赖包，但是安装过程中依旧提示依赖包未安装

分析过程：

--查看已安装依赖包
[root@top132:/etc/yum.repos.d]$ rpm -qa | grep kernel-devel
kernel-devel-3.10.0-1160.114.2.el7.x86_64

--安装过程提示
[root@top132:/opt]$ cd /opt/dbdoctor-3.1.2
[root@top132:/opt/dbdoctor-3.1.2]$ ./dbd -I
......
2024-04-24 09:09:56.520461017 [WARN] [dbd]: kernel-devel-3.10.0-1160.el7.x86_64 is not installed, can not use agent special feature,you can try yum install kernel-devel-3.10.0-1160.el7.x86_64
......
2024-04-24 01:11:10.772248541 [WARN] [service.sh]: The kernel-devel is not installed,the agent can not use special function!
......
2024-04-24 09:11:17.115000948 [WARN] [dbd]: KERNEL or  EBPF is not support, can't open lock button!
......

功能体验

平台管理

以admin账号登录，初始密码123456

登录首页

修改密码(可选)

获取正式License

WebSite: http://192.168.3.132:13000/#/login

DBA User: tester

DBA Password: Root2023!

If you want to set system config,please use admin user to login in.

Admin User: admin

Admin Password: 123456

由于官网下载的安装介质安装后，注册状态显示未注册。

获取正式License方法：License详情中的唯一标识提供给小助手，将小助手提供的注册码复制粘贴到文本框

正式License注册码如下：

XCEFSr5OkKuXPXHit+8ldN9pvrcf/4w20ypKQmolOZ6WQgZ5ursVbBMQYH2Q9FEqYzvaf0VURQkWKtjps3R1Y0rTDxndF9hqKR+S/spV6tAd44KyDUyYQcDbtU2Jx24/lDOj75BbXZu6r5ZprsoZkvgxzZcfi3fH/T0XCktQRuPOhORbTRi51494lHTVpdZz7lASEEQ+MFTfLrp9Lw2Kz8q7e0c1xqfpCL2qNmXc43Ketct2z9zzw2cUacA1qa8lajS9eaLBwHyliCdqdVuzdLqgzW8cUhpPKU5r18qOzkRC+6ucW/TvAO0cPw164WlYKUQ/mnA2mowA7otW+74DLwh51kwNOfE4Q26TIHMSMTYtZ4sF8uDXhssbJq1sBsMfHhNItix1gdtOoFKutu8O+73Jmp/LIdAe4FwQxDKdXS00D1Pkl+1/hrkFB3WQ2ImWinvj4Fs0cmwJ7Q/m9NtZC58Kv/jmYrQ4kTZLsV1vmtwdhuWnCD9R62hgPs2/XstIWYBKP2omrNnu1pR3oPKVglVEDeNauSdrcJORZp3l2L9y0Z2lN3GQeayhftxkQhajyensQ2DK+qY6EBQRaosO4Q6i958Ot6VlTSyskGFcs2dPgbAeH/pSDtLqKoUJCX0IiUJF0mP3SEL6H81nJgXuAt8Z+PdZ+ZDAF4J/STmYwO+DJBsRd9JkUdwMPSJJvEpsDiNzX4xHcZeOS8F4xmuU//LNlfsEkW0pkHD0D1pZe7gyr8M92awFIW2ubf1o65jQgvPC160Pe5zVE1BhapmoY+N5HycjSSCPMoKBHdm/qWrkkfqrhJU/92WNqK1T6dZYaiJ+Qy9Q9/0wFbGtf2ITG4u8aHHWjbyE/aQ0lmgJ11bOn+5Y9piQ52fwGNFNL9UQog070lb0jYgJl3F8B8l19rjL+vchu/SPT646eYu3/jHBb2Bv8H1dQknK0B/2gOwZ+izecnJmf7TKIQM33UEoqacaSqSboqvo+qIwsZy3Ujox9mRPVkT1gScMJu88k2TSYSuXerLteFTL9qse7ZNtUzrU8C1rKiKRbaA+LkGEhCh+oXhubn5A9QanYx2B9fj+1GqbQZvAkIkEHv5aekvMrR6KSAToz527J/OgYwuycbagcbneTp4VyGBKHvdMwujcyvJXc9pe704RSPdL9PXbC0JJi8fHfVoj7T0wz8QxuWEyPKy9arHSg31CbmYko5IcMEgI8jOjRYxyLXdX+xA/8W/w0yAQTinSoXtFtoRVOgUplGRmAiPbr9aby8vaubsmz+4cOdEgwPrycxHCg0q4+rZm/jJdvGI1Ypv+1wnx+rpJEttoq8ELoKj5647EiFlavhHPVD/vdTgWQVu6b6fWmw==

正式License注册

数据采集管理

问题

部署Agent模板呈棕色不可编辑

性能诊断

需以tester账号登录，初始密码Root2023!

登录首页

WebSite: http://192.168.3.132:13000/#/login

DBA User: tester

DBA Password: Root2023!

If you want to set system config,please use admin user to login in.

Admin User: admin

Admin Password: 123456

实例纳管

纳管数据类型：Oracle11.2.0.4 单点

实例纳管前准备

纳管数据库用户权限赋予(必须)

如果不进行权限的赋予，check检测时会报错。

--权限赋予
GRANT SELECT_CATALOG_ROLE TO entservice;
GRANT CREATE SESSION TO entservice;

纳管数据库服务器agent安装(可选)

检测是否安装agent

安装agent

如果未安装，安装下面的步骤进行安装

注意：如果不安装将缺少实例主机相关的关键资源监控数据

wget http://192.168.3.132:13000/download/agent.tar.gz&&tar -zxvf agent.tar.gz&&cd agent&&./agent --install -h 192.168.3.132 -k 192.168.3.132:9092 -s 192.168.3.132:13000

实例纳管步骤

场景1：实例纳管Oracle单点

数据库基本信息

数据洞察配置

数据采集配置

问题描述

当前版本不支持纳管

纳管数据类型：Oracle11.2.0.4 单点

场景2：实例纳管MySQL单点

数据库基本信息

数据洞察配置

数据采集配置

输入主机ip后未提示agent已安装，默认会自动安装。

[root@top132:/opt]$ yum install -y kernel-devel*

若不安装该依赖包，在安装DBdoctor过程中会提示如下警告：

2024-04-24 08:44:12.000782846 [WARN] [dbd]: kernel-devel-3.10.0-1160.el7.x86_64 is not installed, can not use agent special feature,you can try yum install kernel-devel-3.10.0-1160.el7.x86_64
2024-04-24 00:47:02.812803135 [WARN] [service.sh]: The kernel-devel is not installed,the agent can not use special function!
2024-04-24 08:47:07.958191396 [WARN] [dbd]: KERNEL or  EBPF is not support, can't open lock button!

若未配置yum源，则下载并安装

上传rpm包并安装

rpm包下载地址：http://rpmfind.net/linux/centos/7.9.2009/os/x86_64/Packages/kernel-devel-3.10.0-1160.el7.x86_64.rpm

rpm -ivh kernel-devel-3.10.0-1160.el7.x86_64.rpm

问题描述

数据采集连通性检测提示依赖包未安装，但是已经安装