hoo updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
We should check whether it's possible to move `wbc_entity_usage` to an own database shard, away from the main wiki databases.
Open questions:
# There might be places where the information is currently being JOINed against the other tables (API query modules?), we need to look into that and see how hard it would be to do that programmatically.
# How many writes are currently happening on the tables? Can that (plus an order of magnitude?) more easily be sustained if the tables are separate from the main wiki databases?
Question 1. is for the Wikidata team to answer, while 2. probably needs to be answered by a DBA.
Open questions:
# There might be places where the information is currently being JOINed against the other tables (API query modules?), we need to look into that and see how hard it would be to do that programmatically.
# How many writes are currently happening on the tables? Can that (plus an order of magnitude?) more easily be sustained if the tables are separate from the main wiki databases?
Question 1. is for the Wikidata team to answer, while 2. probably needs to be answered by a DBA.
TASK DETAIL
EMAIL PREFERENCES
To: hoo
Cc: jcrespo, Manuel, Marostegui, Halfak, daniel, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, greg, Wikidata-bugs, liangent, jeremyb, aude, Candalua, Bianjiang, Aklapper, DixonD, PokestarFan, hoo, GoranSMilovanovic, QZanden, Izno, Mbch331, Jay8g
Cc: jcrespo, Manuel, Marostegui, Halfak, daniel, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, greg, Wikidata-bugs, liangent, jeremyb, aude, Candalua, Bianjiang, Aklapper, DixonD, PokestarFan, hoo, GoranSMilovanovic, QZanden, Izno, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs