zabbix mysql 监控

最新推荐文章于 2024-07-25 17:06:50 发布
最新推荐文章于 2024-07-25 17:06:50 发布
阅读量1.3k 收藏 2
点赞数
分类专栏： zabbix 文章标签： mysql zabbix
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_38367535/article/details/121270593
版权

创建监控用户(权限usage)：

mysql> grant usage on *.* to zabbix@127.0.0.1 identified by 'zabbix@123';
mysql> flush privileges;

监控脚本：

# cat /etc/zabbix/alertscripts/mysql_status.sh
#!/bin/bash 
#Desc：zabbix 监控 MySQL 状态
#Date：2021-3-1

#主机
HOST="127.0.0.1"
#用户
USER="zabbix"
#密码
PASSWORD="zabbix@123"
#端口
PORT="22809"
#MySQL连接
CONNECTION="/usr/local/mysql/bin/mysqladmin -h ${HOST} -u ${USER} -P ${PORT} -p${PASSWORD}"

if [ $# -ne "1" ];then
    echo "arg error!"
fi

case $1 in
    Uptime)
        result=`${CONNECTION} status 2>/dev/null |awk '{print $2}'`
        echo $result
        ;;
    Questions)
        result=`${CONNECTION} status 2>/dev/null |awk '{print $6}'`
        echo $result
        ;;
    Com_update)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_update" |awk '{print $4}'`
        echo $result
        ;;
    Slow_queries)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Slow_queries" |awk '{print $4}'`
        echo $result
        ;;
    Com_select)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_select" |awk '{print $4}'`
        echo $result
        ;;
    Com_rollback)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_rollback" |awk '{print $4}'`
        echo $result
        ;;
    Com_insert)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_insert" |awk '{print $4}'`
        echo $result
        ;;
    Com_delete)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_delete" |awk '{print $4}'`
        echo $result
        ;;
    Com_commit)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_commit" |awk '{print $4}'`
        echo $result
        ;;
    Bytes_sent)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Bytes_sent" |awk '{print $4}'`
        echo $result
        ;;
    Bytes_received)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Bytes_received" |awk '{print $4}'`
        echo $result
        ;;
    Com_begin)
        result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_begin" |awk '{print $4}'`
        echo $result
        ;;*)
        echo "Usage:$0(Uptime|Questions|Com_update|Slow_queries|Com_select|Com_rollback|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin)"
        ;;
esac

zabbix配置

#mysql监控
UserParameter=mysql.status[*],/etc/zabbix/alertscripts/mysql_status.sh $1


#获取MySQL运行状态（与脚本无关，可以自信忽略）
UserParameter=mysql.ping,/usr/local/mysql/bin/mysqladmin  -u zabbix -h"127.0.0.1" -P22809 -p"zabbix@123" ping 2>/dev/null | grep -c alive

zabbix模板：

# zbx_export_templates.xml


<?xml version="1.0" encoding="UTF-8"?>
<zabbix_export>
    <version>5.0</version>
    <date>2021-11-11T08:35:01Z</date>
    <groups>
        <group>
            <name>Templates/Databases</name>
        </group>
    </groups>
    <templates>
        <template>
            <template>Template DB MySQL custom</template>
            <name>Template DB MySQL custom</name>
            <groups>
                <group>
                    <name>Templates/Databases</name>
                </group>
            </groups>
            <applications>
                <application>
                    <name>MySQL</name>
                </application>
            </applications>
            <items>
                <item>
                    <name>MySQL status</name>
                    <key>mysql.ping</key>
                    <history>1w</history>
                    <description>It requires user parameter mysql.ping, which is defined in userparameter_mysql.conf.&#13;
&#13;
0 - MySQL server is down&#13;
1 - MySQL server is up</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <valuemap>
                        <name>Service state</name>
                    </valuemap>
                    <triggers>
                        <trigger>
                            <expression>{last(0)}=0</expression>
                            <name>MySQL is down</name>
                            <priority>WARNING</priority>
                        </trigger>
                    </triggers>
                </item>
                <item>
                    <name>MySQL bytes received per second</name>
                    <key>mysql.status[Bytes_received]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>Bps</units>
                    <description>The number of bytes received from all clients. &#13;
&#13;
It requires user parameter mysql.status[*], which is defined in &#13;
userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL bytes sent per second</name>
                    <key>mysql.status[Bytes_sent]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>Bps</units>
                    <description>The number of bytes sent to all clients.&#13;
&#13;
It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL begin operations per second</name>
                    <key>mysql.status[Com_begin]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL commit operations per second</name>
                    <key>mysql.status[Com_commit]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL delete operations per second</name>
                    <key>mysql.status[Com_delete]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL insert operations per second</name>
                    <key>mysql.status[Com_insert]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL rollback operations per second</name>
                    <key>mysql.status[Com_rollback]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL select operations per second</name>
                    <key>mysql.status[Com_select]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL update operations per second</name>
                    <key>mysql.status[Com_update]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL queries per second</name>
                    <key>mysql.status[Questions]</key>
                    <history>1w</history>
                    <value_type>FLOAT</value_type>
                    <units>qps</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                    <preprocessing>
                        <step>
                            <type>CHANGE_PER_SECOND</type>
                            <params/>
                        </step>
                    </preprocessing>
                </item>
                <item>
                    <name>MySQL slow queries</name>
                    <key>mysql.status[Slow_queries]</key>
                    <history>1w</history>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                </item>
                <item>
                    <name>MySQL uptime</name>
                    <key>mysql.status[Uptime]</key>
                    <history>1w</history>
                    <units>uptime</units>
                    <description>It requires user parameter mysql.status[*], which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                </item>
                <item>
                    <name>MySQL version</name>
                    <key>mysql.version</key>
                    <delay>1h</delay>
                    <history>1w</history>
                    <trends>0</trends>
                    <value_type>CHAR</value_type>
                    <description>It requires user parameter mysql.version, which is defined in userparameter_mysql.conf.</description>
                    <applications>
                        <application>
                            <name>MySQL</name>
                        </application>
                    </applications>
                </item>
            </items>
            <screens>
                <screen>
                    <name>MySQL performance</name>
                    <hsize>2</hsize>
                    <vsize>1</vsize>
                    <screen_items>
                        <screen_item>
                            <resourcetype>0</resourcetype>
                            <style>0</style>
                            <resource>
                                <name>MySQL operations</name>
                                <host>Template DB MySQL</host>
                            </resource>
                            <width>500</width>
                            <height>200</height>
                            <x>0</x>
                            <y>0</y>
                            <colspan>1</colspan>
                            <rowspan>1</rowspan>
                            <elements>0</elements>
                            <valign>1</valign>
                            <halign>0</halign>
                            <dynamic>0</dynamic>
                            <sort_triggers>0</sort_triggers>
                            <url/>
                            <application/>
                            <max_columns>3</max_columns>
                        </screen_item>
                        <screen_item>
                            <resourcetype>0</resourcetype>
                            <style>0</style>
                            <resource>
                                <name>MySQL bandwidth</name>
                                <host>Template DB MySQL</host>
                            </resource>
                            <width>500</width>
                            <height>270</height>
                            <x>1</x>
                            <y>0</y>
                            <colspan>1</colspan>
                            <rowspan>1</rowspan>
                            <elements>0</elements>
                            <valign>1</valign>
                            <halign>0</halign>
                            <dynamic>0</dynamic>
                            <sort_triggers>0</sort_triggers>
                            <url/>
                            <application/>
                            <max_columns>3</max_columns>
                        </screen_item>
                    </screen_items>
                </screen>
            </screens>
        </template>
    </templates>
    <value_maps>
        <value_map>
            <name>Service state</name>
            <mappings>
                <mapping>
                    <value>0</value>
                    <newvalue>Down</newvalue>
                </mapping>
                <mapping>
                    <value>1</value>
                    <newvalue>Up</newvalue>
                </mapping>
            </mappings>
        </value_map>
    </value_maps>
</zabbix_export>

 

我的喵叫初六
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Zabbix导入mysql监控模板_Zabbix MySQL监控模板添加
weixin_34791250的博客
01-28 214
zabbix自带的mysql监控指标很少，所以需要新增一些监控项1.下载知数堂维护的percona-monitoring-plugin-zabbix代码# cd /opt# wget https://codeload.github.com/zhishutech/percona-monitoring-plugins-zabbix3/zip/master# cdpercona-monitoring-...
zabbix mysql监控报错_zabbix监控mysql
weixin_39620151的博客
02-11 605
这里可以采用zabbix自带的mysql模版，但是也需要在mysql服务器上准备获取mysql status的脚本chk_mysql.sh，zabbix通过调用这个脚本来获取mysql的运行信息。在配置文件zabbix_agentd.conf里面添加mysql监控信息：# vim /etc/zabbix/zabbix_agentd.confUserParameter=mysql.version,m...
zabbix监控mysql
虫虫的博客
05-21 768
zabbix监控mysql
Zabbix 配置MySQL数据库监控
IT
07-04 481
通过 Zabbix 监控 MySQL 数据库，可以获取有关数据库性能、运行状况和资源使用情况的详细信息，帮助及时发现和解决问题。Zabbix官方提供了一个名为的监控模板，该模板专为 Zabbix 通过 Zabbix 代理轻松部署 MySQL 监控而设计，不需要任何外部脚本。
Zabbix监控MySQL数据库
weixin_50877409的博客
10-13 2532
Zabbix监控MySQL数据库
Zabbix监控mysql主从
m0_56681539的博客
09-08 637
将server主机的zabbix.repo复制过来，然后将yum源中的8改成7，接着安装zabbix-agent。
zabbix 监控mysql权限_zabbix-监控mysql
weixin_42513522的博客
01-28 461
监控mysql主要监控myql的连接数、主从同步状态、同步延迟等。实现mysql主从同步从节点配置：1、apt install mysql-server2、vim /etc/mysql/mysql.conf.d/mysqld.cnf[mysqld]bind-address = 0.0.0.0relay-log = /var/lib/mysql/relay-logserver-...
Zabbix5.0监控MySQL
u010554181的博客
05-08 902
Zabbix监控MySQL数据库
Zabbix监控部署及MySQL监控
搬着砖，敲着代码的博客
04-12 1997
zabbix agent安装在被监控的主机上，zabbix agent负责定期收集客户端本地各项数据，并发送至 zabbix server 端，zabbix server 收到数据后，将数据存储到数据库中，用户基于 Zabbix WEB 可以看到数据在前端展现图像。●zabbix server：zabbix 服务端守护进程，其中 zabbix_agent、zabbix_get、zabbix_sender、zabbix_proxy 的数据最终都提交给 zabbix server;
zabbix 监控mysql的方法
01-09
2.编写mysql监控项的脚本 在zabbix-agent先授权个用户 不然测试时没有权限 [root@localhost ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 33 Server ...
zabbix3.2 监控mysql模板
06-11
zabbix监控mysql pecona模板 zabbix 3.0版本可用 zabbix 3.0版本可用
zabbix监控mysql数据库
03-25
zabbix监控mysql数据库详细配置，含监控mysql脚本；
mysql高阶语句
qq_59169480的博客
07-24 921
高级语法的查询语句。
MySQL的存储过程
最新发布
2402_84844434的博客
07-25 1163
完成特定功能的sql语句的集合。把定义好的sql集合在一个特定的sql函数中每次执行调用函数即可。还可以实现传参的调用。
mysql中where与on区别
m0_63227888的博客
07-24 762
使用ON子句来定义表之间的连接条件。使用WHERE子句来过滤查询结果，或者作为连接后结果的进一步筛选条件。在进行表连接时，应优先使用ON子句来指定连接条件，因为这样可以提高查询效率，避免不必要的全表扫描或笛卡尔积。WHERE子句在连接操作后使用，用于过滤连接后的结果集。
Mysql重大更新，三个版本遭下架！
xiaofan23z的专栏
07-24 712
个时就会触发这个重大bug，7/23日mysql发布重要更新，发布了如下三个版本。书接上文，7/11日开源数据库软件服务商percona发布重要警告，最新的。后面官方确认，确实存在重大bug，但是不是表超过10000个，而是超过。当mysql表超过10000张时重启可能会崩溃。
zabbix如何监控mysql
05-18
Zabbix可以通过Zabbix Agent和Zabbix自带的MySQL模板来监控MySQL。以下是具体步骤： 1. 在需要监控的MySQL服务器上安装Zabbix Agent。 2. 下载Zabbix自带的MySQL模板，并将其导入到Zabbix Server中。 3. 在Zabbix...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值