summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-06-04 14:06:16 +0200
committerYorhel <git@yorhel.nl>2020-06-04 14:06:16 +0200
commit1b6d7fbb2eb4ba76d1d2c8844afaf8aa0fe4ab0a (patch)
tree980532f16100b827b2225abae20ba9f87a496255
parent04c9db06ca10e7528e3969d4d6e4eef7903aecc2 (diff)
Multi::Maintenance: Run daily cron at 7:30 UTC + update timing info
-rw-r--r--lib/Multi/Maintenance.pm10
1 files changed, 5 insertions, 5 deletions
diff --git a/lib/Multi/Maintenance.pm b/lib/Multi/Maintenance.pm
index 4f469993..a371f29b 100644
--- a/lib/Multi/Maintenance.pm
+++ b/lib/Multi/Maintenance.pm
@@ -17,7 +17,7 @@ my $monthly;
sub run {
- push_watcher schedule 12*3600, 24*3600, \&daily;
+ push_watcher schedule 7*3600+1800, 24*3600, \&daily; # 7:30 UTC, 30 minutes before the daily DB dumps are created
push_watcher schedule 0, 3600, \&vnsearch_check;
push_watcher pg->listen(vnsearch => on_notify => \&vnsearch_check);
set_monthly();
@@ -65,16 +65,16 @@ my %dailies = (
AND r.released <= TO_CHAR(NOW(), 'YYYYMMDD')::integer
) AS r(id)|,
- # takes about 15 seconds max, still OK
+ # takes about 6 seconds, OK
tagcache => 'SELECT tag_vn_calc(NULL)',
- # takes about 25 seconds, OK
+ # takes about 11 seconds, OK
traitcache => 'SELECT traits_chars_calc(NULL)',
- # takes about 4 seconds, OK
+ # takes about 5 seconds, OK
vnstats => 'SELECT update_vnvotestats()',
- # takes a few seconds, need more data and measurements. This query /should/ not be necessary.
+ # takes about 10 seconds, OK
imagecache => 'SELECT update_images_cache(NULL)',
cleansessions => q|DELETE FROM sessions WHERE expires < NOW()|,