Last modified: 2011-05-26 21:17:56 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 14711 - Implement a namespace filter for the logging table
Implement a namespace filter for the logging table
Status: NEW
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
unspecified
All All
: Low minor with 2 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
http://en.wikipedia.org/wiki/Special:Log
:
: 27865 28487 (view as bug list)
Depends on:
Blocks: 14712 28487
  Show dependency treegraph
 
Reported: 2008-07-03 17:23 UTC by Melancholie
Modified: 2011-05-26 21:17 UTC (History)
8 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Melancholie 2008-07-03 17:23:20 UTC
Special:Log/... does not have a namespace filter like other special pages.
Comment 1 Aryeh Gregor (not reading bugmail, please e-mail directly) 2008-07-03 19:31:25 UTC
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.
Comment 2 Roan Kattouw 2008-07-03 19:40:17 UTC
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.
Comment 3 Aryeh Gregor (not reading bugmail, please e-mail directly) 2008-07-03 19:57:46 UTC
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.)
Comment 4 db [inactive,noenotif] 2011-03-05 14:21:15 UTC
*** Bug 27865 has been marked as a duplicate of this bug. ***
Comment 5 Jeff G. 2011-04-01 20:50:08 UTC
It has been almost three years since this bug was filed. Have Wikimedia wikis' performance increased sufficiently to revisit this bug?
Comment 6 Aryeh Gregor (not reading bugmail, please e-mail directly) 2011-04-01 21:02:56 UTC
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.
Comment 7 Jeff G. 2011-04-02 15:15:39 UTC
(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.
Comment 8 Roan Kattouw 2011-04-03 12:43:25 UTC
(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
Comment 9 Krinkle 2011-04-04 07:02:57 UTC
*** Bug 27709 has been marked as a duplicate of this bug. ***
Comment 10 Mark A. Hershberger 2011-04-11 17:17:57 UTC
*** Bug 28487 has been marked as a duplicate of this bug. ***
Comment 11 Krinkle 2011-05-26 21:17:56 UTC
*** Bug 29139 has been marked as a duplicate of this bug. ***

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links