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@gmail.com wrote:
On 27/08/07, Stephen Bain stephen.bain@gmail.com wrote:
Well in that spirit, could someone take a look at:
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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l