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

Closed - This job posting has been filled and work has been completed.
IT & Networking Database Administration Posted 1 year ago

Fixed Price

Delivery by October 9, 2013

$100.00

Budget

Details

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.


About the Client

(4.99) 32 reviews

United States
Wilton Manors 01:52 AM

64 Jobs Posted
61% Hire Rate, 1 Open Job

Over $50,000 Total Spent
45 Hires, 2 Active

$6.20/hr Avg Hourly Rate Paid
15,472 Hours

Member Since Jul 2, 2009