How to proceed towards MySQL performance testing for Drupal?
First tool, that can be used, is Devel - it will show there's long calls have been made. 
And there's many tools for perfomancing and tuning mysql in internet.