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