zabbix监控mysql数据库——增删改查_mysql zabbix 查询主机新增操作

首先可以继续顺着zabbix监控mysql继续往下做
1.首先在42的继续编写增删改查

Com_delete)
mysqladmin -ucheck -p123 extended-status |grep -w “Com_delete”|awk ‘{print $4}’
;;
Com_update)
mysqladmin -ucheck -p123 extended-status |grep -w “Com_update”|awk ‘{print $4}’
;;
Com_select)
mysqladmin -ucheck -p123 extended-status |grep -w “Com_select”|awk ‘{print $4}’
;;
Com_commit)
mysqladmin -ucheck -p123 extended-status |grep -w “Com_commit”|awk ‘{print $4}’
;;
Com_rollback)
mysqladmin extended-status |grep -w “Com_rollback”|awk ‘{print $4}’
;;
2.web页面进行创建