[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-16 Thread BBlack
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-10 Thread Addshore
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-10 Thread gerritbot
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,

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-08 Thread daniel
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,

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-08 Thread Addshore
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,

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-08 Thread Addshore
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-03 Thread Addshore
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-03 Thread Milimetric
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-03 Thread BBlack
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-02 Thread Addshore
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-02 Thread gerritbot
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-01 Thread Addshore
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-01 Thread daniel
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:

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-01 Thread daniel
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

[Wikidata-bugs] [Maniphest] [Commented On] T125392: [Task] figure out the ratio of page views by logged-in vs. logged-out users

2016-02-01 Thread Addshore
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