Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N | awk '{print $$2}'
- UserParameter=mysql.size[*],echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from information_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema='$1'")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name='$2'");" | HOME=/var/lib/zabbix mysql -N
- UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
- UserParameter=mysql.version,mysql -V
- UserParameter=repSBM,echo "show slave statusG;" | HOME=/etc/zabbix mysql | grep 'Seconds_Behind_Master' | awk '{print $2}'
- UserParameter=repIOrun,echo "show slave statusG;" | HOME=/etc/zabbix mysql | grep -c 'Slave_IO_Running: Yes'
- UserParameter=repSQLrun,echo "show slave statusG;" | HOME=/etc/zabbix mysql | grep -c 'Slave_SQL_Running: Yes'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement