| hoo added a comment. |
I am a bit lost with the estimation- is that realistic, is the number of usages more or less right with your estimation, or is it going to be a quadratic _expression_ because we do not know accurately the number of statement usages per statement?
I guess we can't know for sure, but going for more wikis and then re-running the numbers should get us a better idea.
Also, some rows/indexes are going away at some point (or may be confusing tables)?
eu_touched is supposed to be dropped (T144010), but that's it.
I do not see a reason not to keep deploying except if they are too dynamic (writes increase too much), in which case we should then check the idea of separating those.
This should not be the case (the initial deployment might hit hard, though). On big template/ module changes the table might see quite some changes, but I don't think this is much out of the usual.
Offtopic: wb_terms, on the wikidata server, has become a 700GB beast- that worries me more for maintenance reasons.
After moving the search to elastic, we don't need some of the fields and indexes there anymore (probably term_search_key and term_weight and the associated indexes). Also two fields (term_entity_id, term_entity_type) will be dropped and we had a problem with duplicate rows.
Cc: Bawolff, eranroz, Ottomata, PokestarFan, Ladsgroup, Stashbot, gerritbot, Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, Wikidata-bugs, liangent, jeremyb, aude, Bianjiang, Aklapper, DixonD, daniel, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Marostegui, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
