[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 aklap...@wikimedia.org changed: What|Removed |Added Version|1.21.3 |1.21.x -- You

[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 sprin...@wikimedia.org changed: What|Removed |Added Status|NEW |RESOLVED

[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 bjor...@wikimedia.org --- 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

[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 sprin...@wikimedia.org --- 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

[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) legoktm.wikipe...@gmail.com changed: What|Removed |Added CC|

[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 sprin...@wikimedia.org --- 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

[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 sprin...@wikimedia.org changed: What|Removed |Added See Also|

[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 aklap...@wikimedia.org changed: What|Removed |Added Priority|Unprioritized |Normal -- You

[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 aklap...@wikimedia.org changed: What|Removed |Added Keywords||performance --

[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 sprin...@wikimedia.org --- Actually, I picked on ApiQueryRandom because it *seems* to be the source of the queries. SpecialRandompage apparently already limits page_namespace values using