MySQL Client Add
/etc/zabbix/zabbix_agentd.d, Userparameter_mysql.confuserparameter=mysql.version,mysql- Vuserparameter=mysql.status[*],/etc/zabbix/scripts/chk_mysql.sh $1userparameter= Mysql.ping,mysqladmin-uzabbix-p123456-p3306-h10. 0.0. 6 ping | Grep-c Alive
MySQL Client monitoring script
mkdir/etc/zabbix/scripts/Touch/etc/zabbix/scripts/chk_mysql.shchmod u+x/etc/zabbix/scripts/Chk_mysql.shchown-R zabbix.zabbix/etc/zabbix/scripts/chk_mysql.sh/etc/zabbix/scripts/chk_mysql.sh#!/bin/sh#-------------------------------------------------------------------------------# author:kk# Email: [Email protected]163. Commysql_pwd='123456'Mysql_host='127.0.0.1'Mysql_port='3306'Echo"Please input one arguement:"fi Case$1 inchecho $result;; Com_update) echo $result;; Slow_queries);; Com_select) echo $result;; Com_rollback) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w"Com_rollbacK"|cut-d"|"-f3 'echo $result;; Questions) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock status|cut-f4-d":"|cut-f1-d"S"' echo $result;; Com_insert) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w"Com_insert"|cut-d"|"-F3 ' Echo $result;; Com_delete) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w"Com_delete"|cut-d"|"-F3 ' Echo $result;; Com_commit) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w"Com_commit"|cut-d"|"-F3 ' Echo $result;; Bytes_sent) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w"bytes_sent"|cut-d"|"-F3 ' Echo $result;; bytes_received) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w"bytes_receiVed"|cut-d"|"-f3 'echo $result;; Com_begin) Result= '/application/mysql/bin/mysqladmin-u$mysql_user-h$mysql_host-p${mysql_pwd}-S $MYSQL _sock 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
MySQL Stress test command
Mysqlslap-a-I. 10000-UROOT-P123.ASD
Server-Side execution gets the client host name
/application/zabbix/bin/zabbix_get-s 10.0.0.6-p 10050-k "System.hostname"
Server execution get client key value
/application/zabbix/bin/zabbix_get-s 10.0.0.6-p 10050-k "System.cpu.load[all,avg15]"
Server execution get client key value
/application/zabbix/bin/zabbix_get-s 10.0.0.6-p 10050-k "Mysql.status[uptime]"
Zabbix monitoring MySQL script (for reference only)