WMDE-leszek edited the task description. (Show Details) |
EDIT DETAILS
General plan for the whole schema change is:
1. Add term_entity_id_s VARBINARY(32) to wb_terms. All values NULL
2. Populate term_entity_id_s based on existing data in wb_termsCurrent schema change plan (as suggested by Jaime)
31. Create index on term_entity_sa new column with new indexes
4. Create index on term_language,2. term_entity_id_sPopulate new column at the same time than the current one (ideally with code, term_typebut if you do not want to touch code, term_search_key(16)it can even be made with a trigger) + populate old values with maintenance
53. Drop old column term_entity_id from wb_terms.Deploy the new code using only the new column
6.4. At some point in the future, Rename term_entity_id_s to term_entity_iddrop the old column (it can be made all null and it will save space already) -low priority
...
**Background:**General plan for the whole schema change is:
1. Add term_entity_id_s VARBINARY(32) to wb_terms. All values NULL
2. Populate term_entity_id_s based on existing data in wb_termsCurrent schema change plan (as suggested by Jaime)
31. Create index on term_entity_sa new column with new indexes
4. Create index on term_language,2. term_entity_id_sPopulate new column at the same time than the current one (ideally with code, term_typebut if you do not want to touch code, term_search_key(16)it can even be made with a trigger) + populate old values with maintenance
53. Drop old column term_entity_id from wb_terms.Deploy the new code using only the new column
6.4. At some point in the future, Rename term_entity_id_s to term_entity_iddrop the old column (it can be made all null and it will save space already) -low priority
TASK DETAIL
EMAIL PREFERENCES
To: WMDE-leszek
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: jcrespo, Marostegui, Lydia_Pintscher, Aklapper, daniel, WMDE-leszek, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs