DROP ALL TABLES в MySQL

The heading at this note is a bit wrong. In MySQL there is no such command, and it would be desirable, that it was. Sometimes there are problems in which we want to remove all tables of a DB, but not her (that there were its parametres, such as access rights, codings, etc.). To...

Monitor SELinux with Zabbix

Add the following to the end of /etc/zabbix/zabbix_agentd.conf # SELinux Keys UserParameter=selinux.status,/usr/sbin/sestatus | grep status | awk ‘{print $NF}’ | sed s/enabled/1/ | sed s/disabled/0/ UserParameter=selinux.mode,if ]; then /usr/sbin/sestatus | grep mode | awk ‘{print $NF}’ | sed s/enforcing/1/ | sed s/permissive/0/; else echo 2; fi UserParameter=selinux.boolean,if [[ $(/usr/sbin/sestatus...

Monitor PostgreSQL with Zabbix

Submitted by bchavet on Mon, 01/16/2012 – 17:33 # PostgreSQL Keys UserParameter=psql.version,/usr/bin/psql –version | head -n 1 UserParameter=psql.size,/usr/bin/psql -t -c “select sum(pg_database_size(datid)) as total_size from pg_stat_database” UserParameter=psql.stat,/usr/bin/psql -t -c “select sum($1) from pg_stat_database” ‹ Monitor Nginx with Zabbix...

Monitor Nginx with Zabbix

Configure a new nginx server listening on an alternate port (61709 in this example). This allows access to this information to be controlled. server { listen 61709; location / { stub_status on; access_log off; allow 127.0.0.1; deny all; } } Reload Nginx /etc/init.d/nginx reload Add the following to the end of /etc/zabbix/zabbix_agentd.conf #Nginx Keys...

Scroll to top