prometheus监控耗时MySQL_使用prometheus+grafana监控MySQL监控Oracle

加载mysqld_exporter

cd prometheus_exporter/mysqld_exporter-0.12.1.linux-amd64

创建MySQL数据库监控用户：

create user mysql_monitor@'%' identified by 'Mysql_monitor123';

GRANT REPLICATION CLIENT, PROCESS ON *.* TO mysql_monitor@'%';

GRANT SELECT ON performance_schema.* TO mysql_monitor@'%';

vim .my.cnf

[client]

host=localhost

port=3306

user=mysql_monitor

password=Mysql_monitor123

后台运行服务

nohup ./mysqld_exporter --config.my-cnf=.my.cnf &

加载oracle_exporter

下载oracle客户端安装包,配置安装，需要19C

https://www.oracle.com/cn/database/technologies/instant-client/linux-x86-64-downloads.html

这里使用root用安装19C的客户端

rpm -ivh oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm

[root@oracle21 prometheus_exporter]# rpm -ivh oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm

Preparing...                          ################################# [100%]

Updating / installing...

1:oracle-instantclient19.5-basic-19################################# [100%]

[root@oracle21 prometheus_exporter]# cd /usr/lib/oracle/19.3/client64/network/admin

-bash: cd: /usr/lib/oracle/19.3/client64/network/admin: No such file or directory

[root@oracle21 prometheus_exporter]# cd /usr/lib/oracle/19.5/client64/

[root@o