IMO we should have echo and flow databases on analytics-store even if this use case is served by Event Logging data. The whole point of having so many databases replicated on that machine is to make for easy to do cross DB joins.
Neil, If you file a DBA task, please CC me. :) On Fri, Oct 9, 2015 at 4:40 PM, Leila Zia <[email protected]> wrote: > > On Fri, Oct 9, 2015 at 1:26 PM, Neil P. Quinn <[email protected]> > wrote: > >> I'm trying to gather some stats on the use of Echo notifications across >> wikis, and I'd like to join the `echo_events` table with the `user` table >> for a given wiki. >> > > I'm not sure what kind of information you need but there is a chance that > they are captured via schema in which case you can get them from Echo > schema in log database and then join that with enwiki.user. I'm also not > sure what info you need from enwiki.user, you may be able to get more > global info from centralauth.globaluser. > > Leila > > >> >> -- >> Neil P. Quinn <https://meta.wikimedia.org/wiki/User:Neil_P._Quinn-WMF>, >> product analyst >> Wikimedia Foundation >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
