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 vote142 views1 answer
Postgres check for foreign key
SQL
0 vote212 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote157 views1 answer
Sql server for loop
SQL
0 vote144 views2 answers
Sql drop view if exists
SQL
1 vote152 views1 answer
Add many column to sap iq table
SQL
0 vote155 views1 answer
Grant owner postgresql
SQL
0 vote155 views1 answer
How to update sql server version
SQL
0 vote138 views1 answer
Zerar auto increment mysql
SQL
-1 vote164 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote148 views1 answer
Alter precision
SQL