Maatkit is great for profiling your MySql queries in production. http://www.maatkit.org/