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

9 votes335 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
1 vote332 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote344 views1 answer
Sql server remove enter from string
SQL
0 vote325 views1 answer
Oracle create table auto generated primary key
SQL
0 vote360 views2 answers
SQL FROM
SQL
0 vote324 views1 answer
Mysql Error Code: 1005
SQL
0 vote374 views2 answers
Plpgsql
SQL
0 vote344 views1 answer
Postgres statistics
SQL
17 votes356 views4 answers
Mysql remove ubuntu
SQL
1 vote325 views1 answer
Mysql connect command
SQL