Implement a namespace filter for the logging table
OpenPublic

Description

Author: Wiki.Melancholie

Description:
Special:Log/... does not have a namespace filter like other special pages.


Version: unspecified
Severity: minor
URL: http://en.wikipedia.org/wiki/Special:Log

bzimport added a subscriber: Unknown Object (MLST).
bzimport set Reference to bz14711.
bzimport created this task.Via LegacyJul 3 2008, 5:23 PM
bzimport added a comment.Via ConduitJul 3 2008, 7:31 PM

ayg wrote:

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.

Catrope added a comment.Via ConduitJul 3 2008, 7:40 PM

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.

bzimport added a comment.Via ConduitJul 3 2008, 7:57 PM

ayg wrote:

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.)

duplicatebug added a comment.Via ConduitMar 5 2011, 2:21 PM
  • Bug 27865 has been marked as a duplicate of this bug. ***
bzimport added a comment.Via ConduitApr 1 2011, 8:50 PM

RSYQFIOJGWZA wrote:

It has been almost three years since this bug was filed. Have Wikimedia wikis' performance increased sufficiently to revisit this bug?

bzimport added a comment.Via ConduitApr 1 2011, 9:02 PM

ayg wrote:

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.

bzimport added a comment.Via ConduitApr 2 2011, 3:15 PM

RSYQFIOJGWZA wrote:

(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.

Catrope added a comment.Via ConduitApr 3 2011, 12:43 PM

(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

Krinkle added a comment.Via ConduitApr 4 2011, 7:02 AM
  • Bug 27709 has been marked as a duplicate of this bug. ***
MarkAHershberger added a comment.Via ConduitApr 11 2011, 5:17 PM
  • Bug 28487 has been marked as a duplicate of this bug. ***
Krinkle added a comment.Via ConduitMay 26 2011, 9:17 PM
  • Bug 29139 has been marked as a duplicate of this bug. ***
duplicatebug removed a subscriber: duplicatebug.Via WebDec 13 2014, 11:40 AM
Betacommand added a subscriber: Betacommand.Via WebJan 1 2015, 2:00 PM

Can we please get some progress on this? you cannot filter per namespace.Try searching for just mainspace deletions.... You cant. Try using the prefix: Template: you dont get template space deletions.

Krinkle removed a subscriber: Krinkle.Via WebJan 30 2015, 7:49 PM
Glaisher added a subscriber: Glaisher.Via WebFeb 3 2015, 1:00 PM
Cenarium added a comment.Via WebFeb 4 2015, 6:39 AM

The advanced review log of FlaggedRevs has a namespace filter, see QualityOversight_body.php. It uses what is described as a "cutoff time (mainly for performance)". Looks like it can be adapted for the deletion logs and others, doesn't this solve the performance issue ?

The advanced review log also filters for action type. Doing the same would be useful for other logs, e.g. to sort between deletions, undeletions and selective deletions - see T19806. A general namespace filter for Special:Log wouldn't make sense in my opinion, since many logs aren't tied uniquely to a namespace. Instead, I would suggest an 'advanced log' special page for each of the deletion, protection, block and move logs. This way, each log type would have the most relevant options.

Move is a bit tricky, though, since we need the namespaces for both source and target page. The target title is hardcoded in log_param, so its namespace could be retrieved from there. But what of the namespace of the source page ? We'd better not use the page id, since the page may have been moved again and changed namespace, plus it became the id for the moved page in T59084. I'm not sure which one is returned by log_namespace ?

Reguyla moved this task to Logs on the MediaWiki-Special-pages workboard.Via WebMay 26 2015, 12:30 PM
Ricordisamoa added a subscriber: Ricordisamoa.Via WebJun 19 2015, 10:15 AM

Add Comment