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 <[email protected]>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/Tutorial > > -- slides at > > > https://commons.wikimedia.org/wiki/File:MediaWikiPerformanceProfiling.pdf > > > > Asher Feldman's > > https://www.mediawiki.org/wiki/File:MediaWiki_Performance_Profiling.ogv > > -- slides at > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
