Last modified: 2014-05-09 07:25:51 UTC
It would be cool if those tables could be made available. They essentially contain cached versions of special pages, which mostly isn't useful to people, but on occasion can be. entries in querycache table with qc_type = Unwatchedpages, may be considered sensitive. Nothing else in these two tables is sensitive afaik.
This will require an okay from legal (though I do not anticipate difficulties).
Only concern that I can see is how often these get stale? is there any risk that a page with sensitive content would be suppressed or reverted but still available through the cache?
(In reply to Luis Villa (personal-for work use lvilla@wikimedia.org) from comment #2) > Only concern that I can see is how often these get stale? is there any risk > that a page with sensitive content would be suppressed or reverted but still > available through the cache? Yes. Most are updated once every 4 days, some take longer. But in that case i believe it would still be visible on main site (not 100% sure about that, but pretty sure)
You mean, we're still showing suppressed stuff on the main site in some cases? Or that more generally we may just have some stale caching around?
(In reply to Luis Villa (WMF Legal) from comment #4) > You mean, we're still showing suppressed stuff on the main site in some > cases? Or that more generally we may just have some stale caching around? If someone deletes a page, (and then suppresses it or whatever) the page name may still appear on some list special pages for a bit of time - e.g. mostlinkedtopages and the like. However nobody can view the content of such a page, just that it was on the list