In case no one posts with expriences directly matching your own, it might be helpful for you to post both your current traffic and performance profile as well as your current host and how happy you are with your performance there.
For instance, DreamHost is no magic bullet, performance-wise. If you are at another decent shared host and can’t get good performance there, it is doubtful you’d get great performance here (though I suppose there could be specific circumstances that dictate otherwise).
There is some limited information on MySQL load in the following wiki article:
Free unique IP and $67 off with code [color=#CC0000]LMIP67[/color] or use [color=#CC0000]LM97[/color] for $97 off. Click for more promo code discounts