| Ladsgroup added a comment. |
Thanks. This is a sample of slow queries in tendril which it might be useful. Some slow queries (I don't see any slow write queries causing replication lag)
Just improvements in the database queries not probably related to this bug
- SELECT /* ApiQueryPagePropNames::execute */ DISTINCT pp_propname FROM page_props` ORDER BY pp_propname LIMIT 501 /* eca54e37324ba61f23cd87946fe72863 db2059 wikidatawiki 29s */` (We don't have index on pp_propname, we probably should)
- SELECT /* Wikibase\TermSqlIndex::fetchTerms */ term_entity_type, term_type, term_language, term_text, term_entity_id FROM wb_terms` WHERE term_entity_type = 'property' AND term_entity_id IN ('243', '1036', '1054', '675', '957', '212', '921', '345', '1899', '625', '106', '1344', '3417', '279', '1343', '1889', '3832', '3797', '3788', '699', '585', '495', '361', '703', '1315', '1711', '244', '366', '734', '2283', '2079', '176', '571', '1128', '69', '136', '1659', '405', '2578', '248') AND term_language = 'en' AND term_type IN ('label', 'description') /* 00b21093309916582c83809bac85cbcd db2045 wikidatawiki 293s */` This is strange. We have index on term_language, term_entity_id.
TASK DETAIL
EMAIL PREFERENCES
To: Ladsgroup
Cc: Marostegui, Ladsgroup, Aklapper, StudiesWorld, aaron, daniel, aude, Lydia_Pintscher, Multichill, jcrespo, hoo, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
Cc: Marostegui, Ladsgroup, Aklapper, StudiesWorld, aaron, daniel, aude, Lydia_Pintscher, Multichill, jcrespo, hoo, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
