Last modified: 2011-05-26 21:17:56 UTC
Special:Log/... does not have a namespace filter like other special pages.
Note that you can already filter Special:Log by page prefix, which could easily include filtering just by namespace (although it currently doesn't). This functionality is disabled on Wikimedia wikis for performance reasons. I can't recall what the rationale was for that, and no comment explains why $wgMiserMode is used, so I don't know if it would apply to namespace filtering.
Bug 14712 could be related: the list=logevents API module used to have an lenamespace parameter, but I removed it because Aaron Schulz reported the associated database queries were slow.
Thinking about it, I see the reason. You can't use the index for sorting if you retrieve by prefix. It has to either be filesorted, or retrieved from some other index like log_timestamp and filtered. So that won't be able to run acceptably, no, not without another index on (log_namespace, log_timestamp), and you'd have to have all sorts of other tiresome permutations to get namespace filtering to work well in conjunction with others. This is fine to add as an improvement for the page prefix filtering, but it's not going to be able to run on Wikimedia. (Now let me add a comment to that code.)
*** Bug 27865 has been marked as a duplicate of this bug. ***
It has been almost three years since this bug was filed. Have Wikimedia wikis' performance increased sufficiently to revisit this bug?
It's not about "Wikimedia wikis' performance", it's about how indexes work in MySQL. The performance considerations I discuss in comment 3 have not changed in several years and are unlikely to change for the foreseeable future.
(In reply to comment #1) > Note that you can already filter Special:Log by page prefix, which could easily > include filtering just by namespace (although it currently doesn't). This > functionality is disabled on Wikimedia wikis for performance reasons. Is the ability to filter Special:Log by page prefix still "disabled on Wikimedia wikis for performance reasons"? If so, is the reasoning behind it being disabled still sound? Thanks.
(In reply to comment #7) > (In reply to comment #1) > > Note that you can already filter Special:Log by page prefix, which could easily > > include filtering just by namespace (although it currently doesn't). This > > functionality is disabled on Wikimedia wikis for performance reasons. > Is the ability to filter Special:Log by page prefix still "disabled on > Wikimedia wikis for performance reasons"? If so, is the reasoning behind it > being disabled still sound? Thanks. Yes and yes, per comment 6
*** Bug 27709 has been marked as a duplicate of this bug. ***
*** Bug 28487 has been marked as a duplicate of this bug. ***
*** Bug 29139 has been marked as a duplicate of this bug. ***
