Big Fish Games serves over 2.5 million visitors per month (Quantcast rank 511). Here is a case study of how it optimised mysql using the MySQL Query Analyzer (and used memcached).