| Marostegui added a comment. |
This is how the table looks like after removing all the indexes that are not needed:
Table: wb_terms Create Table: CREATE TABLE `wb_terms` ( `term_row_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `term_entity_id` int(10) unsigned NOT NULL, `term_full_entity_id` varbinary(32) DEFAULT NULL, `term_entity_type` varbinary(32) NOT NULL, `term_language` varbinary(32) NOT NULL, `term_type` varbinary(32) NOT NULL, `term_text` varbinary(255) NOT NULL, `term_search_key` varbinary(255) NOT NULL, `term_weight` float unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`term_row_id`), KEY `wb_terms_text` (`term_text`), KEY `term_full_entity` (`term_full_entity_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2259289467 DEFAULT CHARSET=binary
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: Stashbot, 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: Stashbot, 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 Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
