The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We have a MySQL database running MyISAM engine.
our database has over 40 million records. we just recently built a machine to handle all queries for this database. We need someone who can optimize MySQL my.ini file to handle all the system resources and optimize our table to get maximum performance.
OS: Windows 7 Premium 64-bit
running Apache2triad as our control panel that is using PHP & MySQL 5.
the main use of this server is to handle all of our opt-in email data and used to search and query for particular information. currently takes around 20 seconds to query all data we have for the state of New York, we would like to cut this down to a few seconds.
MySQL is not optimized to use our machine resources and we need an expert who will be able to make the changes and tweaks, document what was done, and leave a step by step instruction guide on how to do this in case this needs to be done again in the future.
Sign in or Register to see more