CentOS6u9 Zabbix2.2安装配置监控告警(六)导入配置MySQL第三方模板

简单说明:

本文从 http://www.showerlee.com/archives/658 转载,相应的脚本和模板文件在该博客可以下载到

修改配置文件,手动添加检测关键字:

目标端操作

rm -rf /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
CMD=$(which mysql)
USER=zabbix_chk
PASS=zabbix_chk
cd /etc/zabbix/zabbix_agentd.d
cat >userparameter_mysql.conf<<EOF
UserParameter=mysql.Ping,${CMD}admin -u${USER} -p${PASS}  ping|grep alive|wc -l
UserParameter=mysql.Threads,${CMD}admin -u${USER} -p${PASS}  status|cut -f3 -d":"|cut -f1 -d"Q"
UserParameter=mysql.Questions,${CMD}admin -u${USER} -p${PASS}  status|cut -f4 -d":"|cut -f1 -d"S"
UserParameter=mysql.Slowqueries,${CMD}admin -u${USER} -p${PASS}  status|cut -f5 -d":"|cut -f1 -d"O"
UserParameter=mysql.Qps,${CMD}admin -u${USER} -p${PASS}  status|cut -f9 -d":"
UserParameter=mysql.Slave_IO_State,if [ "\$(${CMD} -u${USER} -p${PASS}  -e "show slave status\G"| grep Slave_IO_Running|awk '{print \$2}')" == "Yes" ];then echo 1; else echo 0;fi
UserParameter=mysql.Slave_SQL_State,if [ "\$(${CMD} -u${USER} -p${PASS}  -e "show slave status\G"| grep Slave_SQL_Running|awk '{print \$2}')" == "Yes" ];then echo 1; else echo 0;fi
UserParameter=mysql.Key_buffer_size,${CMD} -u${USER} -p${PASS}  -e "show variables like 'key_buffer_size';"| grep -v Value |awk '{print \$2/1024^2}'
UserParameter=mysql.Key_reads,${CMD} -u${USER} -p${PASS}  -e "show status like 'key_reads';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Key_read_requests,${CMD} -u${USER} -p${PASS}  -e "show status like 'key_read_requests';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Key_cache_miss_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'key_reads';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'key_read_requests';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/\$2*100)}'
UserParameter=mysql.Key_blocks_used,${CMD} -u${USER} -p${PASS}  -e "show status like 'key_blocks_used';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Key_blocks_unused,${CMD} -u${USER} -p${PASS}  -e "show status like 'key_blocks_unused';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Key_blocks_used_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'key_blocks_used';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'key_blocks_unused';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/(\$1+\$2)*100)}'
UserParameter=mysql.Innodb_buffer_pool_size,${CMD} -u${USER} -p${PASS}  -e "show variables like 'innodb_buffer_pool_size';"| grep -v Value |awk '{print \$2/1024^2}'
UserParameter=mysql.Innodb_log_file_size,${CMD} -u${USER} -p${PASS}  -e "show variables like 'innodb_log_file_size';"| grep -v Value |awk '{print \$2/1024^2}'
UserParameter=mysql.Innodb_log_buffer_size,${CMD} -u${USER} -p${PASS}  -e "show variables like 'innodb_log_buffer_size';"| grep -v Value |awk '{print \$2/1024^2}'
UserParameter=mysql.Table_open_cache,${CMD} -u${USER} -p${PASS}  -e "show variables like 'table_open_cache';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Open_tables,${CMD} -u${USER} -p${PASS}  -e "show status like 'open_tables';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Opened_tables,${CMD} -u${USER} -p${PASS}  -e "show status like 'opened_tables';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Open_tables_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'open_tables';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'opened_tables';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/(\$1+\$2)*100)}'
UserParameter=mysql.Table_open_cache_used_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'open_tables';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show variables like 'table_open_cache';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/(\$1+\$2)*100)}'
UserParameter=mysql.Thread_cache_size,${CMD} -u${USER} -p${PASS}  -e "show variables like 'thread_cache_size';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Threads_cached,${CMD} -u${USER} -p${PASS}  -e "show status like 'Threads_cached';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Threads_connected,${CMD} -u${USER} -p${PASS}  -e "show status like 'Threads_connected';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Threads_created,${CMD} -u${USER} -p${PASS}  -e "show status like 'Threads_created';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Threads_running,${CMD} -u${USER} -p${PASS}  -e "show status like 'Threads_running';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_free_blocks,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_free_blocks';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_free_memory,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_free_memory';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_hits,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_hits';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_inserts,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_inserts';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_lowmem_prunes,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_lowmem_prunes';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_not_cached,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_not_cached';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_queries_in_cache,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_queries_in_cache';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_total_blocks,${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_total_blocks';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Qcache_fragment_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_free_blocks';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_total_blocks';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/\$2*100)}'
UserParameter=mysql.Qcache_used_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show variables like 'query_cache_size';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_free_memory';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",(\$1-\$2)/\$1*100)}'
UserParameter=mysql.Qcache_hits_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_hits';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Qcache_inserts';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",(\$1-\$2)/\$1*100)}'
UserParameter=mysql.Query_cache_limit,${CMD} -u${USER} -p${PASS}  -e "show variables like 'query_cache_limit';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Query_cache_min_res_unit,${CMD} -u${USER} -p${PASS}  -e "show variables like 'query_cache_min_res_unit';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Query_cache_size,${CMD} -u${USER} -p${PASS}  -e "show variables like 'query_cache_size';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Sort_merge_passes,${CMD} -u${USER} -p${PASS}  -e "show status like 'Sort_merge_passes';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Sort_range,${CMD} -u${USER} -p${PASS}  -e "show status like 'Sort_range';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Sort_rows,${CMD} -u${USER} -p${PASS}  -e "show status like 'Sort_rows';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Sort_scan,${CMD} -u${USER} -p${PASS}  -e "show status like 'Sort_scan';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Handler_read_first,${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_first';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Handler_read_key,${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_key';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Handler_read_next,${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_next';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Handler_read_prev,${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_prev';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Handler_read_rnd,${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_rnd';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Handler_read_rnd_next,${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_rnd_next';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Com_select,${CMD} -u${USER} -p${PASS}  -e "show status like 'com_select';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Com_insert,${CMD} -u${USER} -p${PASS}  -e "show status like 'com_insert';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Com_insert_select,${CMD} -u${USER} -p${PASS}  -e "show status like 'com_insert_select';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Com_update,${CMD} -u${USER} -p${PASS}  -e "show status like 'com_update';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Com_replace,${CMD} -u${USER} -p${PASS}  -e "show status like 'com_replace';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Com_replace_select,${CMD} -u${USER} -p${PASS}  -e "show status like 'com_replace_select';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Table_scan_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Handler_read_rnd_next';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'com_select';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/\$2*100)}'
UserParameter=mysql.Open_files,${CMD} -u${USER} -p${PASS}  -e "show status like 'open_files';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Open_files_limit,${CMD} -u${USER} -p${PASS}  -e "show variables like 'open_files_limit';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Open_files_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'open_files';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show variables like 'open_files_limit';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/\$2*100)}'
UserParameter=mysql.Created_tmp_disk_tables,${CMD} -u${USER} -p${PASS}  -e "show status like 'created_tmp_disk_tables';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Created_tmp_tables,${CMD} -u${USER} -p${PASS}  -e "show status like 'created_tmp_tables';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Created_tmp_disk_tables_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'created_tmp_disk_tables';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'created_tmp_tables';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/\$2*100)}'
UserParameter=mysql.Max_connections,${CMD} -u${USER} -p${PASS}  -e "show variables like 'max_connections';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Max_used_connections,${CMD} -u${USER} -p${PASS}  -e "show status like 'Max_used_connections';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Max_connections_used_rate,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Max_used_connections';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show variables like 'max_connections';"| grep -v Value |awk '{print \$2}')| awk '{printf("%1.4f\n",\$1/\$2*100)}'
UserParameter=mysql.Table_locks_immediate,${CMD} -u${USER} -p${PASS}  -e "show status like 'Table_locks_immediate';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Table_locks_waited,${CMD} -u${USER} -p${PASS}  -e "show status like 'table_locks_waited';"| grep -v Value |awk '{print \$2}'
UserParameter=mysql.Engine_select,echo \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'Table_locks_immediate';"| grep -v Value |awk '{print \$2}') \$(${CMD} -u${USER} -p${PASS}  -e "show status like 'table_locks_waited';"| grep -v Value |awk '{print \$2}')| awk '{printf("%5.4f\n",\$1/\$2)}'
EOF
/etc/init.d/zabbix-agent restart

网页导入MySQL模板:

这里写图片描述

这里写图片描述

这里写图片描述

将模板改名,和原有模板区分开
这里写图片描述

网页添加MySQL监控:

这里写图片描述

这里写图片描述

这里写图片描述

[TOC]

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值