Template MySQL Zabbix agent

UserParameter=mysql.ping[*], mysqladmin -h"$1" -P"$2" ping
UserParameter=mysql.get_status_variables[*], mysql -h"$1" -P"$2" -sNX -e "show global status"
UserParameter=mysql.version[*], mysqladmin -s -h"$1" -P"$2" version
UserParameter=mysql.db.discovery[*], mysql -h"$1" -P"$2" -sN -e "show databases"
UserParameter=mysql.dbsize[*], mysql -h"$1" -P"$2" -sN -e "SELECT COALESCE(SUM(DATA_LENGTH + INDEX_LENGTH),0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"
UserParameter=mysql.replication.discovery[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"
UserParameter=mysql.slave_status[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"

Similar codes

6 votes152 views2 answers
Mysql set primary key
SQL
0 vote164 views1 answer
Difference between 2 query results sql server
SQL
16 votes179 views3 answers
Get count of duplicate records
SQL
3 votes156 views1 answer
Oracle sleep
SQL
3 votes166 views2 answers
See mysql users ubuntu
SQL
1 vote171 views2 answers
Mysql limit offset
SQL
0 vote159 views1 answer
Linked server delete openquery
SQL
1 vote172 views2 answers
Sql where is not number
SQL
0 vote149 views1 answer
Mysql select last 15 minutes
SQL
0 vote156 views1 answer
Select last N rows mysql
SQL