Marostegui created this task.
Marostegui added projects: Wikidata, Pybal, Traffic.
Restricted Application added a subscriber: Aklapper.
Restricted Application added a project: wdwb-tech.

TASK DESCRIPTION
  While deploying a schema change (T284375 
<https://phabricator.wikimedia.org/T284375>) on s8 master, with replication 
enabled, a few of the replicas reached too many connections.
  The cause is the following queries piling up on codfw s8 replicas
  
  P16523 (An Untitled Masterwork) <https://phabricator.wikimedia.org/P16523>
  
  These queries seem to be queries to monitor the mw status of the hosts, 
requesting `Special:Blankpage` from LVS
  
  There are several things that probably need fixing here:
  
  - This query isn't cheap
  - We might want to rate limit this query somehow.
  - This makes impossible to deploy schema changes with replication on the 
standby DC for certain big tables.

TASK DETAIL
  https://phabricator.wikimedia.org/T284981

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Aklapper, Marostegui, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, mark, Ladsgroup, Addshore, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

Reply via email to