[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
WMDE-leszek removed a project: Wikidata-Ministry-Of-Magic-Tech-Debt. TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: WMDE-leszekCc: Stashbot, gerritbot, jcrespo, Marostegui, Nikerabbit, Edgars2007, thiemowmde, Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Lordiis, GoranSMilovanovic, lisong, 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
[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
WMDE-leszek added a project: Wikidata-Ministry-Of-Magic-Tech-Debt. TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: WMDE-leszekCc: Stashbot, gerritbot, jcrespo, Marostegui, Nikerabbit, Edgars2007, thiemowmde, Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Lordiis, GoranSMilovanovic, lisong, 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
[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
gerritbot added a project: Patch-For-Review. TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: gerritbot, jcrespo, Marostegui, Nikerabbit, Liuxinyu970226, Edgars2007, thiemowmde, Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Lordiis, GoranSMilovanovic, lisong, 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
[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
jcrespo added a project: DBA.jcrespo added a comment. Adding #DBA to support the setup of this test db.TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: jcrespoCc: jcrespo, Marostegui, Nikerabbit, Liuxinyu970226, Edgars2007, thiemowmde, Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Lahi, Gq86, GoranSMilovanovic, lisong, QZanden, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
Ladsgroup added a parent task: T188992: Make wb_terms table fancy. TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: thiemowmde, Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
Lucas_Werkmeister_WMDE added a project: Wikidata-Ministry-Of-Magic-Kanban-Board. TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Lucas_Werkmeister_WMDECc: thiemowmde, Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T188279: Investigate optimzing wb_terms
Ladsgroup added a project: Wikidata-Sprint-2018-02-28.Ladsgroup updated the task description. (Show Details) CHANGES TO TASK DESCRIPTION`wb_terms` with 1.4B rows (with average of 140 bytes per row) is one of the biggest tables on wikidata.org that needs cleanun in several areas: up in several areas: - Drop `term_entity_id` (and maybe `term_entity_type`) in favor of `term_full_entity_id`. We just switched to reading from term_full_entity_id everywhere. - Drop- Normalize `term_entity_id` (and maybe `term_entity_type`) in favor of `term_full_entity_id`type` (item=0, property=1, etc.) if we are not dropping it. It's better to be a settings file - Normalize `term_entity_type` (item=0label=0, property=1, etc.) if we are not dropping itetc.). It's better to be a settings file - Normalize `term_type` (label=0lang` (en=0, een-gb =1, etc.) in either another table or a settings file How we are going to normalize (where to store the mapping) and migration plan needs to be determined.TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Lucas_Werkmeister_WMDE, Aklapper, WMDE-leszek, RazShuty, daniel, Lydia_Pintscher, Ladsgroup, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
