BBlack added a comment.
In https://phabricator.wikimedia.org/T125392#1994242, @Milimetric wrote:
> @BBlack - so you think cache_status is not even close to accurate? Do we
> have other accurate measurements of it so we could compare to what extent
> it's misleading? I'm happy to remove it
Addshore added a comment.
In https://phabricator.wikimedia.org/T125392#2014443, @daniel wrote:
> @Addshore nice, thanks!
>
> So, the conclusion is: we have less than 1% logged in page views. Wow, that's
> a lot lower than I expected!
>
> Closing this as resolved.
Yep, this includes all types
gerritbot added a comment.
Change 267869 merged by jenkins-bot:
Add loggedIn X-Analytics Header
https://gerrit.wikimedia.org/r/267869
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore,
daniel added a comment.
What's the status of this now? Do we have the data we want?
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore, daniel
Cc: JanZerebecki, Milimetric, BBlack, ori,
Addshore added a comment.
Running the query to pull the data out for the past 7 days now!
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: JanZerebecki, Milimetric, BBlack, ori,
Addshore added a comment.
@daniel new numbers can be seen at
https://docs.google.com/spreadsheets/d/1hXwFiNFhaMqIF4p3myiVlsQpbiyDvyX_GGHLgPc_I9o/edit?usp=sharing
now
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
Addshore added a comment.
In https://phabricator.wikimedia.org/T125392#1993813, @BBlack wrote:
> FYI - "cache_status" is not an accurate reflection of anything. I'm not sure
> why we really even log it for analytics. The problem is that it only
> reflects some varnish state about the first
Milimetric added a comment.
@BBlack - so you think cache_status is not even close to accurate? Do we have
other accurate measurements of it so we could compare to what extent it's
misleading? I'm happy to remove it from the data if it's really bad.
TASK DETAIL
BBlack added a comment.
FYI - "cache_status" is not an accurate reflection of anything. I'm not sure
why we really even log it for analytics. The problem is that it only reflects
some varnish state about the first of up to 3 layers of caching, and even then
it does so poorly.
TASK DETAIL
Addshore added a comment.
So with a small hack we have some data since midnight.
It can be found at
https://docs.google.com/spreadsheets/d/1hXwFiNFhaMqIF4p3myiVlsQpbiyDvyX_GGHLgPc_I9o/edit?usp=sharing
Also see the patch above for a possible better solution here!
TASK DETAIL
gerritbot added a subscriber: gerritbot.
gerritbot added a comment.
Change 267869 had a related patch set uploaded (by Addshore):
Add loggedIn X-Analytics Header
https://gerrit.wikimedia.org/r/267869
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
Addshore added a comment.
In https://phabricator.wikimedia.org/T125392#1987025, @daniel wrote:
> ...can you limit the query to the item namespace? That should provide us with
> the numbers we need.
So some more numbers for the same period:
NS 0 & USER ONLY
cache_statuscount
pass
daniel added a comment.
...can you limit the query to the item namespace? That should provide us with
the numbers we need.
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore, daniel
Cc:
daniel added a subscriber: daniel.
daniel added a comment.
@addshore: So, vcl_pass would cover anything that bypasses caches? That
includes (most) API requests, (most) special pages (including Special:Search),
as well as logged in users viewing regular pages.
TASK DETAIL
Addshore added a comment.
SELECT
cache_status,
count(*) as count
FROM
wmf.webrequest
WHERE
year = 2016
AND month = 01
AND day = 31
AND uri_host = "www.wikidata.org"
AND http_method = "GET"
GROUP BY cache_status
ORDER BY count
LIMIT
15 matches
Mail list logo