[root@xx scripts]# ls
table.txt testslownum.py testslowtable.py
[root@xx scripts]# cat testslowtable.py
#!/usr/bin/python
# coding:utf-8
import subprocess
import json
file='/usr/local/zabbix/scripts/table.txt'
tables=[]
with open(file,'r') as f:
for i in f.readlines():
table = i.strip('\n')
tables.append({'{#TABLE_NAME}': table})
print json.dumps({'data': tables}, indent=4, separators=(',', ':'))
结合lepus库
[root@xx zabbix_agentd.conf.d]# cat slow_num.conf
UserParameter=slowtable.discovery,/usr/bin/python /usr/local/zabbix/scripts/testslowtable.py
UserParameter=slowtable.nums[*],sudo /usr/bin/python /usr/local/zabbix/scripts/testslownum.py $1
#chmod g-wx,o-wx ~/.cache/Python-Eggs
zabbix添加
主要是每天的慢查询各个库的查询数量,做这个,主要看下每个库的查询数量,目前发现读比写多。
本文转自 liqius 51CTO博客,原文链接:http://blog.51cto.com/szgb17/1980016,如需转载请自行联系原作者