jcrespo created this task. jcrespo added a project: Wikidata. |
TASK DESCRIPTION
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 issues with improvements. 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:
https://logstash.wikimedia.org/goto/a94c6c3ffe941fc83616d18adfc372f8
17830 52 7 134,376 db2038, db2045, db2052, db2059, db2066 wikiuser wikidatawiki SELECT /* Wikibase\TermSqlIndex::fetchTerms */ term_entity_type, term_type, term_language, term_text, term_entity_id FROM `wb_terms` WHERE term_entity_type = 'item' AND term_entity_id IN ('5682', '11573', '2807', '46857', '119', '96', '34726', '1028', '513', '48278', '235', '8851', '649', '122224', '9077', '8027', '38076', '345', '2831', '9933') AND term_language = 'es' AND term_type = 'description' /* 031a7f86378ef40d4240a44ad46a3cbf db2059 wikidatawiki 11s */
253 325 102 25,836 db2038, db2045, db2052, db2059, db2066 wikiuser wikidatawiki SELECT /* Wikibase\TermSqlIndex::getMatchingTerms */ term_entity_type, term_type, term_language, term_text, term_entity_id, term_weight FROM `wb_terms` WHERE ((term_language = 'en' AND (term_search_key LIKE 'aut%' ) AND term_type = 'label' AND term_entity_type = 'item') OR (term_language = 'en' AND (term_search_key LIKE 'aut%' ) AND term_type = 'alias' AND term_entity_type = 'item')) LIMIT 5000 /* c4de2b8173b064fb59493feca2567115 db2052 wikidatawiki 7s */
TASK DETAIL
EMAIL PREFERENCES
To: jcrespo
Cc: hoo, Aklapper, Marostegui, jcrespo, QZanden, Izno, Wikidata-bugs, aude, Mbch331
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