| Marostegui added a comment. |
@Ladsgroup can you confirm which indexes we have to drop? There are tw different patches and the syntax doesn't match what we have in production:
These are the patches:
DROP INDEX /*i*/term_search_key ON /*_*/wb_terms; DROP INDEX /*i*/term_search_full ON /*_*/wb_terms;
DROP INDEX /*i*/term_search ON /*_*/wb_terms; DROP INDEX /*i*/term_entity ON /*_*/wb_terms;
These are the ones we have in core.
-> KEY `wb_terms_entity_id` (`term_entity_id`), -> KEY `wb_terms_text` (`term_text`), -> KEY `wb_terms_search_key` (`term_search_key`), -> KEY `tmp1` (`term_language`,`term_type`,`term_entity_type`,`term_search_key`), -> KEY `term_full_entity` (`term_full_entity_id`), -> KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))
Can you confirm which ones we have to delete as part of this task? (I know we are handling tmp1 on a different task).
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: gerritbot, Marostegui, Aklapper, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Maathavan, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: gerritbot, Marostegui, Aklapper, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Maathavan, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
