Page MenuHomePhabricator

Allow to update some events with higher frequency
Closed, ResolvedPublic

Description

As of now, each update of the database updates all covered events (20 as time of writing). But while updating very often (say, every 10 minutes) monuments2018 while WLM 2018 is running, we don’t really need to do the same for eg WLM 2014.

Especially given how we got into trouble with overloading the DB servers (T180566 & T180014).

The tool should be able to operate a different frequency on subsets of the whole data.

Event Timeline

Mentioned in SAL (#wikimedia-cloud) [2018-09-06T18:56:23Z] <JeanFred> Deploy latest from Git master: 87ae7f0, 3e82527, 686c39b, 720ba09, b82eeb9, 3d327cc, c7d304b, 9a572c8, 1df570c, f75bc85 (T203702)

$ crontab -l
*/15 * * * * jsub -l release=trusty -mem 1000m -once -j y -o /data/project/wikiloves/logs/update-database.log -N update_database_high /data/project/wikiloves/wikiloves/bin/update_database.sh monuments2018 >> /data/project/wikiloves/logs/crontab.log

56 0 * * * jsub -l release=trusty -mem 1000m -once -j y -o /data/project/wikiloves/logs/update-database.log -N update_database_low /data/project/wikiloves/wikiloves/bin/update_database.sh >> /data/project/wikiloves/logs/crontab.log

monuments2018 will update every 15 minutes ; the entire dataset will update once a day.