| WMDE-leszek added a comment. |
Thanks @Mahir256, @Magnus, @Nikki for comments, that's very helpful!
@Mahir256 to clarify:
It is also my go-to table whenever there is some cleaning up of labels to be done
Do I interpret correctly that you are generally running such queries regarding labels only? (That's not a leading question, just trying to get more data :))
@Magnus: that's plenty of tools. We'll come up with some solution, for sure.
Regarding PetScan: querying wb_terms happens in regards to labels only, though, right?
I will instead direct all angry users to @WMDE-leszek :-]
That is of course a part of any migration path we'll provide!
@Daniel_Mietchen: simply put, the table has grown too big, and it is not really maintainable. There has been several incidents in last months related to the table, and all short-term measures that have been attempted to improve the situation have failed. On the more general level, it seems (which can also be seen by reading comments in only this ticket), that the table serves many diverse needs/use cases, but it is not really perfect in any of them.
To clarify, I take it as my failure to communicate it clearly: We are certain wb_terms sql table as it is now cannot continue to be used on such big Wikibase installation as Wikidata. That said, the plan is not simply phase it out, but to introduce replacements that scale better, and better serve particular needs and use cases.
As an example one could think of ElasticSearch being now used on Wikidata as the search engine, as the wb_terms as the as the search index was not usable any more (due to amount of data in the table).
So thank you all for the input so far, and of course we're waiting for more!
wb_terms is not going to turned off without the announcement and a reasonable grace period AND without having replacements in place.
Cc: Daniel_Mietchen, Nikki, Magnus, Mahir256, Nikerabbit, GoranSMilovanovic, Lea_Lacroix_WMDE, WMDE-leszek, Aklapper, Lahi, Gq86, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
