MySQL: Optimizing Stored Routines
Roland Bouman published his presentation for the MySQL User Conference and Expo 2010 on optimizing MySQL stored routines. His recommendations are based on test measurements using benchmark() function.
The summary is short but could be very useful.