daniel added a comment. |
Ok, here is what I plan to do:
- make sha1 field nullable. That way, we can easily stop writing it to preserve space, without the need for a schema change.
- no page IDs in the content or slots tables. Since we won't use native MySQL partitioning, we can introduce the fields if and when we create the shards - or leave them out if we don't need them then.
- I'll make slot_revision a bigint to avoid the need to alter the table when rev_id becomes a bigint.
But we'll do some benchmarking to see how that impacts join performance. If performance degrades because of the difference in the field width, we'll have to think about making slot_revision 32 bit for now.
TASK DETAIL
EMAIL PREFERENCES
To: daniel
Cc: Marostegui, cicalese, Abit, brion, Anomie, jcrespo, gerritbot, Aklapper, daniel, E1presidente, Ramsey-WMF, Jmmuguerza, SandraF_WMF, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Acer, Lewizho99, Maathavan, Susannaanas, Wikidata-bugs, PKM, Base, matthiasmullie, aude, Ricordisamoa, Fabrice_Florin, Raymond, Mbch331
Cc: Marostegui, cicalese, Abit, brion, Anomie, jcrespo, gerritbot, Aklapper, daniel, E1presidente, Ramsey-WMF, Jmmuguerza, SandraF_WMF, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Acer, Lewizho99, Maathavan, Susannaanas, Wikidata-bugs, PKM, Base, matthiasmullie, aude, Ricordisamoa, Fabrice_Florin, Raymond, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs