[Wikidata-bugs] [Maniphest] [Commented On] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover
gerritbot added a comment. Change 349424 merged by jenkins-bot: [mediawiki/extensions/Wikibase@master] Use smaller batches in TermSqlIndex::getTermsOfEntities https://gerrit.wikimedia.org/r/349424TASK DETAILhttps://phabricator.wikimedia.org/T163544EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, gerritbotCc: gerritbot, hoo, Aklapper, Marostegui, jcrespo, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover
jcrespo added a comment. I was thinking on https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_eq_range_index_dive_limit but that is probably more wishful thinking than practical give we are on MariaDB 10.TASK DETAILhttps://phabricator.wikimedia.org/T163544EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, jcrespoCc: gerritbot, hoo, Aklapper, Marostegui, jcrespo, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover
hoo added a comment. From #wikimedia-databases: jynus: For the first query in https://phabricator.wikimedia.org/T163544 how many term_entity_id would be ok? Right now we don't batch there at all, but I can add that rather easily Would 10 be ok? I would say 9 I thin 10 is the limit to start getting in some cases bad queries (approximate cardinality) Ok, that's fineTASK DETAILhttps://phabricator.wikimedia.org/T163544EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: gerritbot, hoo, Aklapper, Marostegui, jcrespo, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover
gerritbot added a comment. Change 349429 merged by jenkins-bot: [mediawiki/extensions/Wikibase@master] Only retrieve up to 2500 terms in TermSqlIndex https://gerrit.wikimedia.org/r/349429TASK DETAILhttps://phabricator.wikimedia.org/T163544EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, gerritbotCc: gerritbot, hoo, Aklapper, Marostegui, jcrespo, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover
gerritbot added a comment. Change 349429 had a related patch set uploaded (by Hoo man): [mediawiki/extensions/Wikibase@master] Only retrieve up to 2500 terms in TermSqlIndex https://gerrit.wikimedia.org/r/349429TASK DETAILhttps://phabricator.wikimedia.org/T163544EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, gerritbotCc: gerritbot, hoo, Aklapper, Marostegui, jcrespo, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover
gerritbot added a comment. Change 349424 had a related patch set uploaded (by Hoo man): [mediawiki/extensions/Wikibase@master] Use smaller batches in TermSqlIndex::getTermsOfEntities https://gerrit.wikimedia.org/r/349424TASK DETAILhttps://phabricator.wikimedia.org/T163544EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, gerritbotCc: gerritbot, 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