1.配置mysql,添加监控用的账号,授予查看所有用户线程/连接的权限
GRANT PROCESS ON *.* TO 'zabbix'@'127.0.0.1' identified BY '20c114c4$65bec20@e1eb6ee4d6614ba'; Flush privileges;
2.准备脚本
获取端口的脚本
#!/usr/bin/python import os import json
#获取mysql端口,使用root权限执行获取端口,过滤出mysql的,将':'转为空格,awk过滤出第五列端口列,打印时带上空格分割端口 port=os.popen("sudo netstat -tlnp | grep mysql | sed 's/:/ /g' |awk '{printf $5 " "}'").read() ports=[]
#遍历端口,加入到ports列表 for i in port.split(" "): if i == "": continue ports += [{'{#MYSQLPORT}':"%s"%i}]
#将列表转为str格式的json输出,按照key排序,缩进4个空格，指定keys间分割符为','，KEY与value分割符为':' print json.dumps({'data':ports},sort_keys=True,indent=4,separators=(',',':'))
获取mysql状态的脚本
#!/bin/bash # 用户名 MYSQL_USER='zabbix' # 密码 MYSQL_PWD='20c114c4$65bec20@e1eb6ee4d6614ba' # 主机地址/IP MYSQL_HOST='127.0.0.1' # 端口 MYSQL_PORT=$2 #获取mysql的PID ID=`sudo netstat -tlnp | grep -w mysqld | grep -w $MYSQL_PORT| awk '{print $NF}' | awk -F '/' '{NF-=1;print $NF}'`
#获取mysql的位置 mysql_command=`sudo lsof -p $ID -n | grep -w "bin/mysqld" |awk '{print $NF}'` mysql_command_path=`which \`echo $mysql_command\` | awk -F'/' '{OFS="/";NF-=1;print }'` #获取socket位置 socket=`ps -ef | grep $ID | grep -v grep | sed 's/ / /g' | grep socket | awk -F '=' '{print $2}'` # 数据连接 MYSQL_CONN="$mysql_command_path/mysqladmin -u${MYSQL_USER} -p${MYSQL_PWD} -h${MYSQL_HOST} -P${MYSQL_PORT} -S $socket" ##help函数 help() { echo "Usage:$0 [ping|Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin] port" } # 参数是否正确 if [ $# -lt "2" ];then echo "参数缺失!" help exit 2 fi # 获取数据 case $1 in ping) result=`${MYSQL_CONN} ping | grep -c alive` echo $result ;; 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 ;; version) result=`${MYSQL_CONN} version | grep -w "Server version" | awk '{print $3}'` echo $result ;; *) help ;; esac
3.添加到zabbix_agentd.conf
#mysql ports json
UserParameter=mysql_discovery[*],python /usr/local/zabbix/scripts/discovery_mysql.py #####==command ===port UserParameter=mysql.status[*],/usr/local/zabbix/scripts/check_mysql.sh $1 $2 UserParameter=mysql.ping[*],/usr/local/zabbix/scripts/check_mysql.sh ping $1 UserParameter=mysql.version[*],/usr/local/zabbix/scripts/check_mysql.sh version
#授权zabbix用户，root权限执行netstat和lsof
echo 'zabbix ALL=NOPASSWD:/bin/netstat,/usr/sbin/lsof' >> /etc/sudoers
#将脚本授权为执行权限
chmod +x /usr/local/zabbix/scripts/{discovery_mysql.py,check_mysql.sh}
#属组为zabbix
chown zabbix:zabbix /usr/local/zabbix/scripts/{discovery_mysql.py,check_mysql.sh}
#重启客户端
#添加完毕后到zabbix服务器上测试
/usr/local/zabbix/bin/zabbix_get -s 客户端IP -p 10050 -k mysql_discovery[*]
{
"data":[
{
"{#MYSQLPORT}":"3306"
}
]
}
/usr/local/zabbix/bin/zabbix_get -s 127.0.0.1 -p 10050 -k mysql.ping[3306]
1
/usr/local/zabbix/bin/zabbix_get -s 127.0.0.1 -p 10050 -k mysql.status[Bytes_received,3306]
442796433746
#如果获取不到,可能是超时的问题
到客户端zabbix_agentd.conf添加最长等待时间,这里自定义5代表5秒,范围1-30
Timeout=5
重启客户端,再次尝试
4.创建zabbix自动发现规则
自行导入xml模板查看吧,导入后的模板名为Template OS Linux mysql
然后给需要监控的服务器,添加模板
https://files.cnblogs.com/files/cainiaoit/zbx_export_templates2.xml
<?xml version="1.0" encoding="UTF-8"?> <zabbix_export> <version>3.0</version> <date>2017-08-18T03:43:13Z</date> <groups> <group> <name>Templates</name> </group> </groups> <templates> <template> <template>Template OS Linux mysql</template> <name>Template OS Linux mysql</name> <description/> <groups> <group> <name>Templates</name> </group> </groups> <applications> <application> <name>MySQL</name> </application> </applications> <items/> <discovery_rules> <discovery_rule> <name>Mysql Port Discovery</name> <type>0</type> <snmp_community/> <snmp_oid/> <key>mysql_discovery</key> <delay>60</delay> <status>0</status> <allowed_hosts/> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <delay_flex/> <params/> <ipmi_sensor/> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <filter> <evaltype>0</evaltype> <formula/> <conditions/> </filter> <lifetime>30</lifetime> <description/> <item_prototypes> <item_prototype> <name>MySQL status</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.ping[ {#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap> <name>Service state</name> </valuemap> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL bytes received per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Bytes_received,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>Bps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL bytes sent per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Bytes_sent,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>Bps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL begin operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_begin,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL commit operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_commit,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL delete operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_delete,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL insert operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_insert,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL rollback operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_rollback,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL select operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_select,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL update operations per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Com_update,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL queries per second</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Questions,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>qps</units> <delta>1</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL slow queries</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Slow_queries,{#MYSQLPORT}]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL uptime</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.status[Uptime,{#MYSQLPORT}]</key> <delay>600</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units>uptime</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> <item_prototype> <name>MySQL version</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>mysql.version[ {#MYSQLPORT}]</key> <delay>86400</delay> <history>7</history> <trends>0</trends> <status>0</status> <value_type>1</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>MySQL</name> </application> </applications> <valuemap/> <logtimefmt/> <application_prototypes/> </item_prototype> </item_prototypes> <trigger_prototypes> <trigger_prototype> <expression>{Template OS Linux mysql:mysql.ping[ {#MYSQLPORT}].last(0)}=0</expression> <name>MySQL is down[ {#MYSQLPORT}]</name> <url/> <status>0</status> <priority>2</priority> <description/> <type>0</type> <dependencies/> </trigger_prototype> </trigger_prototypes> <graph_prototypes> <graph_prototype> <name>MySQL bandwidth[{#MYSQLPORT}]</name> <width>900</width> <height>200</height> <yaxismin>0.0000</yaxismin> <yaxismax>100.0000</yaxismax> <show_work_period>1</show_work_period> <show_triggers>1</show_triggers> <type>0</type> <show_legend>1</show_legend> <show_3d>0</show_3d> <percent_left>0.0000</percent_left> <percent_right>0.0000</percent_right> <ymin_type_1>0</ymin_type_1> <ymax_type_1>0</ymax_type_1> <ymin_item_1>0</ymin_item_1> <ymax_item_1>0</ymax_item_1> <graph_items> <graph_item> <sortorder>0</sortorder> <drawtype>5</drawtype> <color>00AA00</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Bytes_received,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>1</sortorder> <drawtype>5</drawtype> <color>3333FF</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Bytes_sent,{#MYSQLPORT}]</key> </item> </graph_item> </graph_items> </graph_prototype> <graph_prototype> <name>MySQL operations[{#MYSQLPORT}]</name> <width>900</width> <height>200</height> <yaxismin>0.0000</yaxismin> <yaxismax>100.0000</yaxismax> <show_work_period>1</show_work_period> <show_triggers>1</show_triggers> <type>0</type> <show_legend>1</show_legend> <show_3d>0</show_3d> <percent_left>0.0000</percent_left> <percent_right>0.0000</percent_right> <ymin_type_1>0</ymin_type_1> <ymax_type_1>0</ymax_type_1> <ymin_item_1>0</ymin_item_1> <ymax_item_1>0</ymax_item_1> <graph_items> <graph_item> <sortorder>0</sortorder> <drawtype>0</drawtype> <color>C8C800</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_begin,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>1</sortorder> <drawtype>0</drawtype> <color>006400</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_commit,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>2</sortorder> <drawtype>0</drawtype> <color>C80000</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_delete,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>3</sortorder> <drawtype>0</drawtype> <color>0000EE</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_insert,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>4</sortorder> <drawtype>0</drawtype> <color>640000</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_rollback,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>5</sortorder> <drawtype>0</drawtype> <color>00C800</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_select,{#MYSQLPORT}]</key> </item> </graph_item> <graph_item> <sortorder>6</sortorder> <drawtype>0</drawtype> <color>C800C8</color> <yaxisside>0</yaxisside> <calc_fnc>2</calc_fnc> <type>0</type> <item> <host>Template OS Linux mysql</host> <key>mysql.status[Com_update,{#MYSQLPORT}]</key> </item> </graph_item> </graph_items> </graph_prototype> </graph_prototypes> <host_prototypes/> </discovery_rule> </discovery_rules> <macros/> <templates/> <screens/> </template> </templates> </zabbix_export>
