Advertisement
Guest User

Untitled

a guest
Jul 31st, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N | awk '{print $$2}'
  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
  3.  
  4. UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
  5. UserParameter=mysql.version,mysql -V
  6. UserParameter=repSBM,echo "show slave statusG;" | HOME=/etc/zabbix mysql | grep 'Seconds_Behind_Master' | awk '{print $2}'
  7. UserParameter=repIOrun,echo "show slave statusG;" | HOME=/etc/zabbix mysql | grep -c 'Slave_IO_Running: Yes'
  8. 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