**文書の過去の版を表示しています。**
zabbixのログ削除
zabbixのログは自動で消されるはずなのだけど、なぜか上手くいっておらず放っておくと1年で20GBくらい増えてしまう。 そこで、次の手順でzabbixのログを消去する。
ssh suikouvm sudo systemctl stop zabbix-server sudo su - postgres psql -qAt -c "DELETE FROM trends WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete trends_units" psql -qAt -c "DELETE FROM trends_uint WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete events" psql -qAt -c "DELETE FROM events WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete alerts" psql -qAt -c "DELETE FROM alerts WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete history" psql -qAt -c "DELETE FROM history WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete history_unit" psql -qAt -c "DELETE FROM history_uint WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete history_log" psql -qAt -c "DELETE FROM history_log WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete history_str" psql -qAt -c "DELETE FROM history_str WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix echo "Delete history_text" psql -qAt -c "DELETE FROM history_text WHERE to_timestamp(clock) < NOW()-INTERVAL '365 days';" zabbix psql -qAt -c "VACUUM FULL trends;" zabbix psql -qAt -c "VACUUM FULL trends_uint;" zabbix psql -qAt -c "VACUUM FULL events;" zabbix psql -qAt -c "VACUUM FULL alerts;" zabbix psql -qAt -c "VACUUM FULL history;" zabbix psql -qAt -c "VACUUM FULL history_uint;" zabbix psql -qAt -c "VACUUM FULL history_log;" zabbix psql -qAt -c "VACUUM FULL history_str;" zabbix psql -qAt -c "VACUUM FULL history_text;" zabbix ... exit sudo systemctl start zabbix-server