Hi, No action required. Just a heads up. Since there were some problems around machine capacities, slow queries and subsequent slave lag and alarms in the past months, springle suggested to point the s[23467]-analytics-slave aliases to the new analytics-store machine. That should kill some of the problems at the root. This migration gets tracked in Bug 66068 [1]. No action is required from you, the change should be transparent. Keep using the aliases in the same manner as you did up to now. This email is merely a heads up about the switch. Have fun, Christian [1] https://bugzilla.wikimedia.org/show_bug.cgi?id=66068 -- ---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Gruendbergstrasze 65a Email: christian(a)quelltextlich.at 4040 Linz, Austria Phone: +43 732 / 26 95 63 Fax: +43 732 / 26 95 63 Homepage: http://quelltextlich.at/ --------------------------------------------------------------- _______________________________________________ Analytics mailing list Analytics(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics

This should not happen until some important indexes have been carried over to analytics store. In other words, block on https://rt.wikimedia.org/Ticket/Display.html?id=7594 please.

Another question: What should we do with s5-analytics-slave? Last year at Aaron's request this was made writable like s1 with staging and personal databases. Could it revert to using analytics-store with only staging? _______________________________________________ Analytics mailing list Analytics(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics

Hi, TL;DR: If you use staging.nov13_dewiki_* tables, speak up! On Wed, Jun 04, 2014 at 02:42:11PM +1000, Sean Pringle wrote: Summing up the last two weeks, * Aaron said that he would not be affected for s5. * No one said thon would oppose the move. The only affected tables visible to the research user seem to be [1]: staging.nov13_dewiki_article_page staging.nov13_dewiki_creation staging.nov13_dewiki_move staging.nov13_dewiki_move_revision staging.nov13_dewiki_page staging.nov13_dewiki_page_origin staging.nov13_dewiki_user_stats Do those tables ring a bell for someone? If no one claims them by 2014-06-26: * I assume the above tables are no longer needed, and they can be dropped, and * I assume we can point the s5-analytics-slave alias to dbstore1002 like for the other slaves from $SUBJECT. Have fun, Christian [1] _________________________________________________________________ qchris@stat1003 // jobs: 0 // time: 21:58:19 // exit code: 0 cwd: ~ mysql --defaults-extra-file=~/.my.cnf.research --host s5-analytics-slave.eqiad.wmnet -e 'show databases;' +--------------------+ | Database | +--------------------+ | information_schema | | dartar | | dewiki | | log | | prod | | rfaulk | | staging | | wikidatawiki | +--------------------+ _________________________________________________________________ qchris@stat1003 // jobs: 0 // time: 21:58:22 // exit code: 0 cwd: ~ for db in dartar log prod rfaulk staging ; do echo $db ; mysql --defaults-extra-file=~/.my.cnf.research --host s5-analytics-slave.eqiad.wmnet -e 'show tables;' $db ; done dartar log prod rfaulk staging +----------------------------+ | Tables_in_staging | +----------------------------+ | nov13_dewiki_article_page | | nov13_dewiki_creation | | nov13_dewiki_move | | nov13_dewiki_move_revision | | nov13_dewiki_page | | nov13_dewiki_page_origin | | nov13_dewiki_user_stats | +----------------------------+ -- ---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ---- Companies' registry: 360296y in Linz Christian Aistleitner Kefermarkterstrasze 6a/3 Email: christian(a)quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/ --------------------------------------------------------------- _______________________________________________ Analytics mailing list Analytics(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics

Those are tables I created for [...] They are no longer needed. They can be deleted immediately.