Cool. Something that I dint know. So far I have changed some table types to innoDB from MyISAM. Rewritten a lot of queries and in some cases maintained redundancy instead of normalization.
As you probably know, the default configs of both - mysql and apache are usually pretty minimalistic so tuning these in accordance with your load/traffic scenarios can pay you off big-time in terms of performance boost.
On that note, I'm sure they have some highly competent people out there at RackSpace who should also be able to help you out with all this.