mysql begin operations_zabbix监控mysql性能

监控脚本：

check_mysql.sh

#!/bin/bash

# 用户名

MYSQL_USER='root'

# 密码

MYSQL_PWD='password'

# 主机地址/IP

MYSQL_HOST='127.0.0.1'

# 端口

MYSQL_PORT='3306'

# 数据连接

MYSQL_CONN="/usr/bin/mysqladmin -u${MYSQL_USER} -h${MYSQL_HOST} -P${MYSQL_PORT} -p{$MYSQL_PWD}"

# 参数是否正确

if [ $# -ne "1" ];then

echo "arg error!"

fi

# 获取数据

case $1 in

Uptime)

result=`${MYSQL_CONN} status|cut -f2 -d":"|cut -f1 -d"T"`

echo $result

;;

Com_update)

result=`${MYSQL_CONN} extended-status |grep -w "Com_update"|cut -d"|" -f3`

echo $result

;;

Slow_queries)

result=`${MYSQL_CONN} status |cut -f5 -d":"|cut -f1 -d"O"`

echo $result

;;

Com_select)

result=`${MYSQL_CONN} extended-status |grep -w "Com_select"|cut -d"|" -f3`

echo $result

;;

Com_rollback)

result=`${MYSQL_CONN} extended-status |grep -w "Com_rollback"|cut -d"|" -f3`

echo $result

;;

Questions)

result=`${MYSQL_CONN} status|cut -f4 -d":"|cut -f1 -d"S"`

echo $result

;;

Com_insert)

result=`${MYSQL_CONN} extended-status |grep -w "Com_insert"|cut -d"|" -f3`

echo $result

;;

Com_delete)

result=`${MYSQL_CONN} extended-status |grep -w "Com_delete"|cut -d"|" -f3`

echo $result

;;

Com_commit)

result=`${MYSQL_CONN} extended-status |grep -w "Com_commit"|cut -d"|" -f3`

echo $result

;;

Bytes_sent)

result=`${MYSQL_CONN} extended-status |grep -w "Bytes_sent" |cut -d"|" -f3`

echo $result

;;

Bytes_received)

result=`${MYSQL_CONN} extended-status |grep -w "Bytes_received" |cut -d"|" -f3`

echo $result

;;

Com_begin)

result=`${MYSQL_CONN} extended-status |grep -w "Com_begin"|cut -d"|" -f3`

echo $result

;;

*)

echo "Usage:$0(Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin)"

;;

esac

修改zabbix_agentd.conf，在结尾添加：

UserParameter=mysql.ping,mysqladmin -uroot -p1ktower.com -P3306 ping | grep -c alive

UserParameter=mysql.version,mysql -V

UserParameter=mysql.status[*],/usr/local/zabbix/scripts/check_mysql.sh $1

重启zabbix_agentd

参数：

MySQL begin operations per second MySQL每秒开始运算

MySQL bytes received per second 每秒接收的MySQL字节数

MySQL bytes sent per second 每秒发送的MySQL字节数

MySQL commit operations per second 每秒MySQL提交操作

MySQL delete operations per second MySQL每秒删除操作数

MySQL insert operations per second MySQL每秒插入操作数

MySQL queries per second 每秒MySQL查询

MySQL rollback operations per second 每秒MySQL回滚操作

MySQL select operations per second MySQL每秒选择操作

MySQL slow queries MySQL慢查询

MySQL status MySQL状态

MySQL update operations per second 每秒MySQL更新操作

MySQL uptime MySQL正常运行时间

MySQL version MySQL版本

Template Percona MySQL Server(percona插件模板)