Shulou(Shulou.com)06/01 Report--

1. Psql database performance monitoring:

1) steps for zabbix-agent client to install pg_monz:

[root@zabbix ~] # tarxfz pg_monz-1.0.1.tar.gz

[root@zabbix ~] # cdpg_monz-1.0.1/pg_monz

[root@zabbixpg_monz] # cp find_dbname.sh find_dbname_table.sh / usr/local/bin/

[root@zabbixpg_monz] # cp userparameter_pgsql.conf / etc/zabbix/zabbix_agentd.d/

[root@zabbixpg_monz] # chmod + x / usr/local/bin/find_dbname.sh

[root@zabbixpg_monz] # chmod + x / usr/local/bin/find_dbname_table.sh

[root@zabbixpg_monz] # / etc/init.d/zabbix-agent restart

2) the zabbix server only needs to import the monitoring template provided in the tar package into the zabbix server.

Reference article: https://yq.aliyun.com/articles/9026

Http://blog.chinaunix.net/uid-20726500-id-4513716.html

Https://github.com/pg-monz/pg_monz/releases

II. Performance monitoring of spl_server database

At present, the monitoring of sql_server database by zabbix is a monitoring template for each organization, and the "Zabbix_Template_SQLServer_MultiDatabase_generator.sql" statement is executed on each organization's sql_server database, and then the generated results are saved as xml files as templates and imported to the zabbix server.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.