There's also "prefstats", the last entry in which is dated 20120321195103. Either I'm mad or these are legacy tables that were previously excluded from replication to the analytics slaves (it's probable that I'm mad).


On 30 April 2014 02:13, Oliver Keyes <okeyes@wikimedia.org> wrote:
Hurrh; that's...weird. So, looking at s1, I now see the same tables as on the One Box, but I swear I haven't seen some of them there before. Examples are exorphans, log_search and filejournal.

Aaron, Dario, Leila: am I crazy, or were these not previously there?


On 29 April 2014 23:42, Sean Pringle <springle@wikimedia.org> wrote:
On Wed, Apr 30, 2014 at 3:39 PM, Oliver Keyes <okeyes@wikimedia.org> wrote:
Also, where are you replicating from? Only there are kind of a lot of tables here I don't recognise.

From each shard using the same replication streams as the sX-analytics-slaves use.

Which tables?


--
DBA @ WMF

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics




--
Oliver Keyes
Research Analyst
Wikimedia Foundation



--
Oliver Keyes
Research Analyst
Wikimedia Foundation