[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2014-06-23 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 Sean Pringle changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2014-06-23 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 Andre Klapper changed: What|Removed |Added Version|1.21.3 |1.21.x -- You are receiving this mail

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-12-20 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 --- Comment #5 from Brad Jorsch --- Gerrit change 102880 fixed the "empty namespace" issue, so this should be closed unless you want to keep it open to address this comment left on that change: > page_random may need some reindexing too, eithe

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-12-19 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 Sean Pringle changed: What|Removed |Added See Also||https://bugzilla.wikimedia.

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-12-19 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 --- Comment #4 from Sean Pringle --- Ah ok, thanks. I went on distinct enwiki page_namespace values. That makes removing the forced index the only solution. -- You are receiving this mail because: You are the assignee for the bug. You are on

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-12-19 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 Kunal Mehta (Legoktm) changed: What|Removed |Added CC||legoktm.wikipe...@gmail.com --

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-12-19 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 --- Comment #2 from Sean Pringle --- The example query above had a FORCE INDEX (page_random) removed during testing: mysql wmf db1043 root enwiki> explain SELECT page_title, page_namespace FROM `page` force index (page_random) WHERE page_name

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-11-25 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 Andre Klapper changed: What|Removed |Added Priority|Unprioritized |Normal -- You are receiving this mail

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-11-20 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 Andre Klapper changed: What|Removed |Added Keywords||performance -- You are receiving this

[Bug 57285] ApiQueryRandom allows slow queries for nonexistant page_namespace

2013-11-19 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=57285 --- Comment #1 from Sean Pringle --- Actually, I picked on ApiQueryRandom because it *seems* to be the source of the queries. SpecialRandompage apparently already limits page_namespace values using MWNamespace::getContentNamespaces(), and noth