X-Git-Url: https://dev.renevier.net/?a=blobdiff_plain;f=scripts%2Fcrontab.syj;h=0360fd4a75f2deafb6f2f9829bff6310a86f0990;hb=96d851254c810af41225f775caf7c6b98fce7de9;hp=e8c0c1157d85eec49cb18bc99393d84d3f14d571;hpb=190fd621df4920c56a422c03663874cddaa67d64;p=syj.git

diff --git a/scripts/crontab.syj b/scripts/crontab.syj
index e8c0c11..0360fd4 100644
--- a/scripts/crontab.syj
+++ b/scripts/crontab.syj
@@ -2,4 +2,10 @@ MAILTO=arno@renevier.net
 # every 5 minutes, call syj php cron
 */5 * * * * /usr/bin/wget --header="Host: osm-syj.crans.org" http://localhost/cron -O /dev/null  -o /dev/null
 # every month, update geoip db
-0 0 3 * * /data/project/syj/scripts/updategeoip.sh
+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