Hello, One update regarding this. We enabled using the new table for Special:Tags in several large wikis which caused a massive improvement in the performance of the page. For example loading Special:Tags on Wikidata used to take around a minute and now it takes less than a second. English Wikipedia is down from ten seconds to less than one and so on.
There is a lot of work needs to be done and maintenance scripts is being ran to backpopulate the ct_tag_id column in change_tag table (If you want to follow the progress, see https://phabricator.wikimedia.org/T193873) and then we need start reading from the new table in mediawiki and finally we can drop ct_tag column entirely. If you want to help in review, writing code or anything, just let me know. Best On Wed, 27 Jun 2018 at 15:15, Léa Lacroix <[email protected]> wrote: > Hello all, > > Our team is refactoring some code around the change tags on Recent > Changes. This can impact people using the database on ToolForge. > > Currently, the tags are stored in the table change_tag in the column > ct_tag. > > In the next days, we will add a column ct_tag_id with a unique identifier > for these tags. A new table change_tag_def that will store the tag id, > the message, and more information like how many times this tag is used on > the local wiki. > > On the long term, we plan to drop the column ct_tag since the tag will be > identified with ct_tag_id. > > This change will happen on: > - French Wikipedia: Monday July 2nd > - All other wikis: from July 9th > > If there is any problem (trouble with saving edits, slow down of recent > changes…) please create a subtask of T185355 > <https://phabricator.wikimedia.org/T185355> or contact Ladsgroup > <https://www.wikidata.org/wiki/User:Ladsgroup>. > > Cheers, > -- > Léa Lacroix > Project Manager Community Communication for Wikidata > > Wikimedia Deutschland e.V. > Tempelhofer Ufer 23-24 > 10963 Berlin > www.wikimedia.de > > Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. > > Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg > unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt > für Körperschaften I Berlin, Steuernummer 27/029/42207. > _______________________________________________ > Wikidata-tech mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata-tech > -- Amir Sarabadani Software Engineer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Tel. (030) 219 158 26-0 http://wikimedia.de Stellen Sie sich eine Welt vor, in der jeder Mensch an der Menge allen Wissens frei teilhaben kann. Helfen Sie uns dabei! http://spenden.wikimedia.de/ Wikimedia Deutschland – Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207. _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
