[Wikidata-bugs] [Maniphest] [Edited] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover

[jcrespo]

jcrespo edited the task description. (Show Details)

EDIT DETAILS

these 2 queries were among the most expensive on datacenter failover or after it- while it is normal to have lower performance than usual due to colder caches, most likely they are surfacing existing issues with improvements, which could be made better even under normal circunstances. It would be nice to have some mitigation in place before the failback happens on the 3 May to avoid the issues mentioned on the parent ticket- even if it is as silly as reducing query batches or job rates:

...

TASK DETAIL

https://phabricator.wikimedia.org/T163544

EMAIL PREFERENCES

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

To: jcrespo
Cc: hoo, Aklapper, Marostegui, jcrespo, QZanden, Izno, Wikidata-bugs, aude, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs