You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

User:Michael Große/Draft/Incident Playbook Delay injecting Recent Changes

From Wikitech-static
< User:Michael Große
Revision as of 10:57, 19 May 2022 by imported>Michael Große
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Questions to ask:

if more jobs are inserted than usual

Figure out if substantially more items with subscribers are being edited than usual:

MariaDB [wikidatawiki]> SELECT SUBSTR(rc_timestamp, 1, 10), COUNT(*) FROM recentchanges JOIN wb_changes_subscription ON rc_title = cs_entity_id WHERE rc_namespace = 0 AND rc_timestamp >= '20220510000000' GROUP BY SUBSTR(rc_timestamp, 1, 10);

Figure out if there are more recent changes at a wiki than usual:

MariaDB [euwiki]> SELECT SUBSTR(rc_timestamp, 1, 10), COUNT(*) FROM recentchanges WHERE rc_timestamp >= '20220509000000' AND rc_source = 'wb' GROUP BY SUBSTR(rc_timestamp, 1, 10);

Figure out if recent changes maybe come from a single, very prolific editor:

MariaDB [euwiki]> SELECT actor_name, COUNT(*) FROM recentchanges JOIN actor ON rc_actor = actor_id WHERE rc_source = 'wb' AND rc_timestamp >= '20220510100000' GROUP BY actor_name ORDER BY COUNT(*) DESC LIMIT 5;

TODO: something something see quickstatements batches


related Grafana dashboards