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_status count pass 6445 hit 14140 miss 234885 Time taken: 528.378 seconds, Fetched: 3 row(s) NS 0 ALL USERS & SPIRDERS cache_status count pass 7405 hit 304905 miss 1996823 Time taken: 556.433 seconds, Fetched: 3 row(s) We decided in IRC that this still doesn't help us determine logged in vs logged out users. This is due to the fact that the first time a logged in user views an item page it is a MISS, and after that it is a PASS Thus its all just a bit to mixed together.... Trying something else now and we should have some rough numbers tomorrow and better numbers at the end of the week. TASK DETAIL https://phabricator.wikimedia.org/T125392 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: daniel, Aklapper, Addshore, Lydia_Pintscher, Izno, Wikidata-bugs, aude, Mbch331 _______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs