#!/bin/sh mysql_pwd= " -usense -p*******" args=1 if [ $# -ne "$ARGS" ];then echo "Please input one arguement:" fi Case $1 in uptime) result= ' mysqladmin ${mysql_pwd} status|cut -f2 -d ': "|cut -f1 -d" T "' echo $result ;; com_update) result= ' Mysqladmin ${mysql_pwd} extended-status |grep -w "Com_update" |cut -d "|" -f3 ' echo $result ;; slow_queries) result= ' mysqladmin ${mysql_pwd} status |cut -f5 -d ":" |cut -f1 -d "O" echo $result ;; com_select) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Com_select" |cut -d "|" -f3 ' echo $result ;; com_rollback) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Com_rollback" |cut -d "|" -f3 ' echo $result ;; questions) result= ' Mysqladmin ${mysql_pwd} status|cut -f4 -d ":" |cut -f1 -d "S" ' echo $result ;; com_insert) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Com_iNsert "|cut -d" | " -f3 ' echo $result ;; com_delete) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Com_delete" |cut -d "|" -f3 ' echo $result ;; com_commit) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Com_commit" |cut -d "|" -f3 ' echo $result ;; bytes_sent) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Bytes_sent" |cut -d "|" -f3 ' echo $result ;; bytes_received) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Bytes_received" |cut -d "|" -f3 ' echo $result ;; com_begin) result= ' mysqladmin ${mysql_pwd} extended-status |grep -w "Com_begin" |cut -d "|" -f3 ' echo $result ;; *) echo "Usage:$0 (uptime| com_update| slow_queries| Com_select| com_rollback| Questions) " ;; esac configuration file: Parameters for your own consideration: userparameter=mysql.status[*],/etc/zabbix/shell/mysqlstatus.sh $1 $2 2>/dev/nullzabbix can write a
This article is from the "Brick Blog" blog, please be sure to keep this source http://wsxxsl.blog.51cto.com/9085838/1906352
Zabbix Monitoring Database