[Wikidata-bugs] [Maniphest] [Commented On] T179066: Drop search indexes on wb_terms table

[hoo]

hoo added a comment.

This basically asks for:

Drop the following fields:

`term_search_key` varbinary(255) NOT NULL,
`term_weight` float unsigned NOT NULL DEFAULT '0',

Drop the following indexes:

KEY `tmp1` (`term_language`,`term_type`,`term_entity_type`,`term_search_key`),
KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

Possible also drop:

KEY `wb_terms_text` (`term_text`),

TASK DETAIL

https://phabricator.wikimedia.org/T179066

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: hoo
Cc: daniel, hoo, Aklapper, Ladsgroup, Lahi, GoranSMilovanovic, QZanden, Wikidata-bugs, aude, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs