Need a MySQL DBA To Performance Tune SugarCRM Database w/ Custom Modules

Closed - This job posting has been filled and work has been completed.

Job Description

We have a SugarCRM database hosted on an Amazon EC2 instance.

We are noticing some queries run very slowly -- saying "copying to tmp table" for extended periods of times when they are run against one of our tables with 1,000,000 records that has several joins. We can supply the my.cnf and sample queries, along with a phpmyadmn login. We are looking for you to suggest changes to my.cnf and if necessary table items and indexes.