|Open||None||T28394 Missing Indexes, Inefficient queries and alike (tracking)|
|Open||None||T24744 Add/Update indexes for queries done by the API (tracking)|
|Resolved||Catrope||T16712 API: logevents do not have a namespace filter|
|Open||None||T16711 Implement a namespace filter for the logging table|
(In reply to comment #1)
It used to have one, but it was removed because filtering on namespace killed
With the current db scheme, it may be killing. But I think through the years many valid bugs and requests have come to depend on such filter.
Reopening with dependancy on bug 14711 which requests the actual filterability.
Note that mw_logging has had an index on (log_namespace, log_title) since it was created in r4919. What is causing the kill actually ? (respond on bug 14711 ?)
(In reply to comment #3)
There is no (namespace,timestamp) index.
r4919 - tables.sql (MediaWiki 1.3A)
KEY page_time (log_namespace, log_title, log_timestamp)
r84394 - tables.sql (MediaWiki 1.18alpha)
CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_timestamp);
[Removing RESOLVED LATER as discussed in http://lists.wikimedia.org/pipermail/wikitech-l/2012-November/064240.html . Reopening and setting priority to "Lowest". For future reference, please use either RESOLVED WONTFIX (for issues that will not be fixed), or simply set lowest priority. Thanks a lot!]