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 <
[email protected]> 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:  [email protected]
> 4293 Gutau, Austria          Phone:          +43 7946 / 20 5 81
>                              Fax:            +43 7946 / 20 5 81
>                              Homepage: http://quelltextlich.at/
> ---------------------------------------------------------------
>
> _______________________________________________
> Analytics mailing list
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/analytics
>
>
_______________________________________________
Analytics mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/analytics

Reply via email to