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

1 vote192 views1 answer
Table valued functions in sql
SQL
0 vote189 views1 answer
Shell script to log mysql cpu usage
SQL
-1 vote265 views1 answer
Minus vs except in sql
SQL
2 votes185 views1 answer
Get hour from date sql
SQL
11 votes185 views2 answers
MySQL DISTINCT
SQL
0 vote191 views1 answer
Mysql 8 error on identified by
SQL
1 vote190 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
10 votes176 views4 answers
Primary key in sql
SQL
0 vote180 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote215 views1 answer
Check command
SQL