I posted the query results at https://phabricator.wikimedia.org/T104942#1458981. I _believe_ there wasn't significant skew on particular days that would taint the initially reported number, although there were small variations as expected.
On Thu, Jul 16, 2015 at 9:33 AM, Adam Baso abaso@wikimedia.org wrote:
No problem, I'll run some extra queries.
On Thu, Jul 16, 2015 at 9:04 AM, John phoenixoverride@gmail.com wrote:
1 day isnt much to base a decision on, especially on a global level. Normally I would use a sample set of at least a week, to a month of values. Sorry if I seem like im being a pain, I have just seen a lot of bad choices made based off limited data sets. With a wider data set we might find that Tuesdays are the slowest day for traffic, or some other factor that skews the data. Ensuring data validation is important when making these types of calls based off the working dataset.
On Thu, Jul 16, 2015 at 11:05 AM, Toby Negrin tnegrin@wikimedia.org wrote:
Hi John --
What do you think would be a better sample? My feeling is that a 24 hour period captures global usage and we're currently at about .01% of page views come to these domains is a pretty good indicator. Keep in mind
we're
doing this for a legitimate technical reason and not arbitrarily.
Looking
at the UAs is a good idea and we will do that.
thanks,
-Toby
On Thu, Jul 16, 2015 at 6:55 AM, John phoenixoverride@gmail.com
wrote:
Can we look at a wider sample? using a single day as judgement factor
is
a
bad idea. However if the data supports your position I dont see any
serious
problems. You might want to take a look at either the UA's or refering sources to see if there is a primary source for the traffic and
mitigate
that.
On Thu, Jul 16, 2015 at 9:03 AM, Adam Baso abaso@wikimedia.org
wrote:
Looks like the user pageviews for wap.wikipedia.org and mobile.wikipedia.org subdomains are approximately 0.02% of the size of pageviews for m.wikipedia.org subdomains based on a recent one day check.
hive> select count(*) from wmf.webrequest where year = 2015 and month = 7 and day = 14 and access_method = 'mobile web' and (uri_host like '%.wap.wikipedia.org' OR uri_host like '%. mobile.wikipedia.org') and is_pageview = true and agent_type = 'user';
35,543
hive> select count(*) from wmf.webrequest where year = 2015 and month = 7 and day = 14 and access_method = 'mobile web' and uri_host like '%.m.wikipedia.org' and is_pageview = true and agent_type = 'user';
202,024,891
On Thu, Jul 16, 2015 at 5:41 AM, John phoenixoverride@gmail.com
wrote:
... Have we done any analysis on usage of those subdomains?
On Thu, Jul 16, 2015 at 8:34 AM, Adam Baso abaso@wikimedia.org
wrote:
> There's a ticket for removing mobile.wikipedia.org and
wap.wikipedia.org
> domains/subdomains, which are legacy domain names superceded by > m.wikipedia.org and its subdomains. > > https://phabricator.wikimedia.org/T104942 > > The rationale for the removal of these legacy domain names is to
help
> support HSTS preloading in browsers with the existing TLS SAN
cert.
> > After review of the ticket, can anyone think of a compelling
reason
to
keep > those old domain names? > > I'm going to open a separate thread on mobile-l about this given
this
is
> more mobile-targeted, yet some people only operate on one of
wikitech-l
or > mobile-l. > > -Adam > _______________________________________________ > Wikitech-l mailing list > Wikitech-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l