See T188993#4052708
mwscript extensions/Wikibase/repo/maintance/clearTermSqlIndexSearchFields.php --wiki=wikidatawiki --batch-size=TODO --sleep=TODO --skip-term-weight
See T188993#4052708
mwscript extensions/Wikibase/repo/maintance/clearTermSqlIndexSearchFields.php --wiki=wikidatawiki --batch-size=TODO --sleep=TODO --skip-term-weight
Project | Branch | Lines +/- | Subject | |
---|---|---|---|---|
operations/puppet | production | +11 -0 | mediawiki: Add clearTermSqlIndexSearchFields for wikidata |
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | • Addshore | T188992 Make wb_terms table fancy | |||
Resolved | Lucas_Werkmeister_WMDE | T188993 Replace term_search_key and term_weight with empty values when wb_terms is not used for search | |||
Declined | Ladsgroup | T189779 Run clearTermSqlIndexSearchFields on Wikidata | |||
Resolved | Lucas_Werkmeister_WMDE | T191631 Add maintenance script to wipe term_search_key and term_weight columns |
rebuildTermSqlIndex.php is probably a lot more expensive than we need – to clear the term_search_key and term_weight columns, we shouldn’t need to load and parse entities. So perhaps some new, small maintenance script that just writes empty values to that column would be better.
hmm, I think we might get away with adding a new parameter to the maintenance script. It makes the work less duplicated, what do you think?
I’m not sure… to clear term_search_key and term_weight, I think it would make sense to iterate over the term_row_id, right? Whereas I assume rebuildTermSqlIndex iterates over entity IDs and then sets all term rows for that entity ID.
Change 427202 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani):
[operations/puppet@production] mediawiki: Add clearTermSqlIndexSearchFields for wikidata
Change 427202 merged by Jcrespo:
[operations/puppet@production] mediawiki: Add clearTermSqlIndexSearchFields for wikidata
We’re working on a replacement for wb_terms and don’t want to risk touching it anymore in the meantime.