このページの2つのバージョン間の差分を表示します。
| 次のリビジョン | 前のリビジョン |
| zabbixログ削除 [2020/04/16 01:17] – 作成 118.240.79.152 | zabbixログ削除 [Unknown date] (現在) – 削除 - 外部編集 (Unknown date) 127.0.0.1 |
|---|
| # 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 | |
| ... | |
| |
| exit | |
| |
| sudo systemctl start zabbix-server | |
| ``` | |
| |
| [[https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/380712-housekeeper-not-deleting-data-zabbix-3-2-postgres]] | |