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@wikimedia.orgwrote:
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/Tut...
-- 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 Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l