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.

In T189779#4081528, @Lucas_Werkmeister_WMDE wrote:

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.

yeah, okay.

Change 427202 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani):
[operations/puppet@production] mediawiki: Add clearTermSqlIndexSearchFields for wikidata

https://gerrit.wikimedia.org/r/427202

Change 427202 merged by Jcrespo:
[operations/puppet@production] mediawiki: Add clearTermSqlIndexSearchFields for wikidata

https://gerrit.wikimedia.org/r/427202