The advice on
https://wikitech.wikimedia.org/wiki/Query_profiling_for_features_developers
sounds
good.
Is there more detail somewhere on how to do this part "Test your query
against production slaves prior to full deployment"?
Luke
On Wed, Mar 6, 2013 at 8:14 PM, Matthew Flaschen <mflaschen(a)wikimedia.org>wrote;wrote:
On 03/06/2013 04:36 PM, Sumana Harihareswara wrote:
If you want your code merged, you need to keep
your database queries
efficient. How can you tell if a query is inefficient? How do you write
efficient queries, and avoid inefficient ones? We have some resources
around:
Roan Kattouw's
https://www.mediawiki.org/wiki/Manual:Database_layout/MySQL_Optimization/Tu…
-- slides at
https://commons.wikimedia.org/wiki/File:MediaWikiPerformanceProfiling.pdf
https://www.mediawiki.org/wiki/File:SQL_indexing_Tutorial.pdf
And
https://wikitech.wikimedia.org/wiki/Query_profiling_for_features_developers
Matt Flaschen
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l