Hiya! Also! We're turning off an A/B test this Thursday afternoon and it would make our lives easier for this renaming thing to happen next week :) please and thank you.
- Mikhail *Imagine a world in which every single human being can freely share in the **sum of all knowledge. That's our commitment.* Donate <https://donate.wikimedia.org/>. On Tue, Mar 21, 2017 at 10:57 AM, Nuria Ruiz <[email protected]> wrote: > > Team: > > We need to do some maintenance work to the evenlogging database that > requires renaming and archiving of all tables that are currently receiving > events. > > Tables will be renamed from, for example: WikipediaZeroUsage_14574251 to > WikipediaZeroUsage_14574251_15423246; > > 15423246 is the capsule schema version. > > As new events are come for 'WikipediaZeroUsage' schema with schema version > 14574251 the table WikipediaZeroUsage_14574251 will get recreated again, > the only difference is that this new table will have different column > length for varchar fields. > > Details of this change are here: https://phabricator.wikimedia.org/T160454 > > We will start our maintenance event on Thursday morning around 11 am PST > time and it would last couple hours, no data loss on eventlogging will > happen as part of this event. > > Reportupdater queries that use eventlogging would need to be updated to > select from the newly renamed tables (and we will take care of doing that) > but other than those we do not think there are any other automated scripts > that would need updating. Please let us know otherwise. > > Also, please be so kind to let us know if this renaming is disruptive in > any way. We can also do this changes at a later time next week. > > Thanks, > > Nuria > > > > > > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
