At Wikimania I spoke with Domas regarding query perf on real wiki
data. Doing EXPLAIN SELECT on a local db is inaccurate for two
reasons:
* devs tend to run the latest MySQL on their machines, not the 4.xxx
that wiki is using (possibly with additional settings that might
affect performance)
* devs tend to have much smaller sample wiki (I use simple.wiki) to
test, and mysql optimizer might choose a different optimization
strategy.
What we need is a simple web-based tool that allows anyone to type in
a sql query, and get the result of "EXPLAIN" statement executed on the
real enwiki. Obviously we must be careful not to introduce a SQL
injection vulnerability.
--Yurik
On 8/27/07, Rob Church <robchur(a)gmail.com> wrote:
On 27/08/07, Stephen Bain
<stephen.bain(a)gmail.com> wrote:
Well in that spirit, could someone take a look
at:
http://bugzilla.wikimedia.org/show_bug.cgi?id=8753
Note the comments on the bug; in particular,
http://bugzilla.wikimedia.org/show_bug.cgi?id=8753#c2 - this is an
example of a bug where it's not clear whether there is a problem to
solve.
http://bugzilla.wikimedia.org/show_bug.cgi?id=10890
...an API improvement, which I imagine that anyone could test though
there are only a few people who do lots of work on the API.
Have you run an EXPLAIN SELECT and checked the performance of the
modified queries?
Rob Church
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/wikitech-l