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 999999;
**31st January 2015**
cache_status count
hit 1001337
pass 1175072
- 1627482
miss 32827343
Time taken: 310.862 seconds, Fetched: 4 row(s)
vcl_hit = if the requested document was found in the cache
vcl_miss = if the requested document was not found in the cache
vcl_pass = the request is passed on to the backend (nocache)
Not sure what the - cache_status means at this stage
TASK DETAIL
https://phabricator.wikimedia.org/T125392
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: 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
