*(If your third-party tool does not read data from [wbc_entity_usage] via Wiki Replicas or SQL, please ignore this email)*
Hello everyone, planning is underway to move the Wikibase [wbc_entity_usage] tables for all wikis to a different database cluster: “x1 extension cluster”, to improve database space usage and potentially free up hundreds of GBs per sN cluster [0]. We expect that few, if any, third-party tools rely directly on this table — but before making any breaking changes, we want to confirm that. If your tool uses this table, hearing from you will help us understand how many tools are affected and what that usage looks like, so we can plan the migration accordingly. [wbc_entity_usage] tracks which Wikidata entities are used on a given Wiki’s pages, and also powers Wikidata-triggered Recent Changes and Watchlist injections to client Wikis. If you operate a tool that reads from [wbc_entity_usage] table - via Wiki Replicas / direct SQL - including JOINs queries to other MediaWiki tables Then please reply to this email or comment on [1] — even a simple “yes, I am” is helpful! If you’re able to share more, it helps us even further: - The Tool name and location (e.g. Toolforge, repo link) - If your query JOIN’s [wbc_entity_usage] with other tables, please tell us which (e.g. "page", "revision") - How often the queries run [wbc_entity_usage], (e.g. real-time, daily, weekly, manually). *Please be aware:* Cross-cluster JOIN queries will no longer work *after* the migration is completed, so they will need to be adjusted. However, old and new tables will be kept ‘in sync’ during the transition period so operating queries should continue to function until the cutoff data / the old tables are turned off. [2] If you have questions, feel free to reply. If you want to report an issue, please comment on [1]. [0] - https://phabricator.wikimedia.org/T424133 [1] - https://phabricator.wikimedia.org/T430289 [2] - <https://phabricator.wikimedia.org/T430289> https://phabricator.wikimedia.org/T424440 <https://phabricator.wikimedia.org/T430289>Thank you, Danny -- *Danny Benjafield* Community Communications Manager Wikidata For Wikimedia Projects Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30-577 11 62-0 https://wikimedia.de Keep up to date! Current news and exciting stories about Wikimedia, Wikipedia and Free Knowledge in our newsletter (in German): Subscribe now. <https://www.wikimedia.de/newsletter/> Imagine a world in which every single human being can freely share in the sum of all knowledge. Help us to achieve our vision! https://spenden.wikimedia.de Wikimedia Deutschland — Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Charlottenburg, VR 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207. Geschäftsführende Vorstände: Franziska Heine
_______________________________________________ Wikidata mailing list -- [email protected] Public archives at https://lists.wikimedia.org/hyperkitty/list/[email protected]/message/MARZHXXHKWHEOBNQCRFROQDK3CPNNT3Q/ To unsubscribe send an email to [email protected]
