Zabbix monitoring database

#! / 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`qladmin $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: consider the parameters yourself: UserParameter=mysql.status [*], / etc/zabbix/shell/mysqlstatus.sh $1 $22 > / dev/nullzabbix can write a