diff options
| author | Yorhel <git@yorhel.nl> | 2020-06-04 14:06:16 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2020-06-04 14:06:16 +0200 |
| commit | 1b6d7fbb2eb4ba76d1d2c8844afaf8aa0fe4ab0a (patch) | |
| tree | 980532f16100b827b2225abae20ba9f87a496255 /lib/Multi | |
| parent | 04c9db06ca10e7528e3969d4d6e4eef7903aecc2 (diff) | |
Multi::Maintenance: Run daily cron at 7:30 UTC + update timing info
Diffstat (limited to 'lib/Multi')
| -rw-r--r-- | lib/Multi/Maintenance.pm | 10 |
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()|, |