cat /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V
UserParameter=mysql_innodb_locks,/data/mysql/bin/mysql -udba -BNe " SELECT count(1) FROM INFORMATION_SCHEMA.INNODB_LOCKS;"
UserParameter=mysql_innodb_waits,/data/mysql/bin/mysql -udba -BNe " SELECT count(1) FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;"
UserParameter=mysql_waitting_flush,/data/mysql/bin/mysql -udba -BNe " select count(1) from information_schema.processlist where state like '%Waiting for table%';"
UserParameter=mysql_master_status,/data/mysql/bin/mysql -udba -e 'show slave status\G' |grep -E "Slave_IO_Running|Slave_SQL_Running"|awk '{print $2}'|grep -c Yes
UserParameter=Seconds_Behind_Master,/data/mysql/bin/mysql -udba -e 'show slave status\G' |grep -E "Seconds_Behind_Master"|awk '{print $2}'
zabbix_get -s 10.102.3.17 -k mysql_master_status
创建mysql监控模板，创建项目，创建触发器
UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V
UserParameter=mysql_innodb_locks,/data/mysql/bin/mysql -udba -BNe " SELECT count(1) FROM INFORMATION_SCHEMA.INNODB_LOCKS;"
UserParameter=mysql_innodb_waits,/data/mysql/bin/mysql -udba -BNe " SELECT count(1) FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;"
UserParameter=mysql_waitting_flush,/data/mysql/bin/mysql -udba -BNe " select count(1) from information_schema.processlist where state like '%Waiting for table%';"
UserParameter=mysql_master_status,/data/mysql/bin/mysql -udba -e 'show slave status\G' |grep -E "Slave_IO_Running|Slave_SQL_Running"|awk '{print $2}'|grep -c Yes
UserParameter=Seconds_Behind_Master,/data/mysql/bin/mysql -udba -e 'show slave status\G' |grep -E "Seconds_Behind_Master"|awk '{print $2}'
zabbix_get -s 10.102.3.17 -k mysql_master_status
创建mysql监控模板，创建项目，创建触发器
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25911813/viewspace-2144714/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
mysql ab复制跳过事物
下一篇：
hbase全备增量备份脚本
请登录后发表评论
登录
全部评论
