Thanks Christian.
Those are tables I created for https://meta.wikimedia.org/wiki/Research:Wikipedia_article_creation. They are no longer needed. They can be deleted immediately.
-Aaron
On Wed, Jun 18, 2014 at 5:15 PM, Christian Aistleitner < christian@quelltextlich.at> wrote:
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:
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?
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics