| jcrespo added a comment. |
This is a bit offtopic to T163551 but with the latest schema changes, wb_terms has become the largest table on a wiki (with the exception of revision on enwiki and image on commons)- and I think it will get bigger once the new column (I assume) gets populated with actual data. The data size is not a problem, but monolithical tables get progresively harder to manage (to a point in which schema changes are really difficult) and progresively slower. Anything done to reduce the individual size per table may help- starting by reducing the huge number of indexes.
Note that something as easy as setting up a separate service/db shard to track changes is not out of the question, as I have suggested some time ago.
TASK DETAIL
EMAIL PREFERENCES
To: jcrespo
Cc: jcrespo, aude, Aklapper, hoo, QZanden, Izno, Wikidata-bugs, Mbch331
Cc: jcrespo, aude, Aklapper, hoo, QZanden, Izno, Wikidata-bugs, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
