clear lighttpd compress cache in cron

[syj.git] / scripts / crontab.syj

diff --git a/scripts/crontab.syj b/scripts/crontab.syj
index 78d48bee268730f9b87cf3c5722aa9d36e610a5f..0513a3055ed32739c440b27c101d24bc72d29f51 100644 (file)
--- a/scripts/crontab.syj
+++ b/scripts/crontab.syj
@@ -5,3 +5,9 @@ MAILTO=arno@renevier.net
 12 3 3 * * /data/project/syj/scripts/updategeoip.sh
 # every day, delete old sessions files
 47 4 * * * find /tmp/ -name "sess_*" -user syj  -ctime +45 -exec rm -f '{}' \;
+# every day, vacuum tables
+48 4 * * * psql syj syj -c "VACUUM ANALYZE users" > /dev/null
+48 4 * * * psql syj syj -c "VACUUM ANALYZE paths" > /dev/null
+48 4 * * * psql syj syj -c "VACUUM ANALYZE pending_actions" > /dev/null
+# every day, clear lighttpd compress cache
+12 5 * * * find /data/work/syj/lighttpd/lighttpd-cache -type f -mtime +2 | xargs -r rm