See T188993#4052708
mwscript extensions/Wikibase/repo/maintance/clearTermSqlIndexSearchFields.php --wiki=wikidatawiki --batch-size=TODO --sleep=TODO --skip-term-weight
Description
Description
| Status | 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 |
Event Timeline
Comment Actions
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.
Comment Actions
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?
Comment Actions
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.
Comment Actions
Change 427202 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani):
[operations/puppet@production] mediawiki: Add clearTermSqlIndexSearchFields for wikidata
Comment Actions
Change 427202 merged by Jcrespo:
[operations/puppet@production] mediawiki: Add clearTermSqlIndexSearchFields for wikidata
Comment Actions
We’re working on a replacement for wb_terms and don’t want to risk touching it anymore in the meantime.