176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySQL Administrator needed for optimization
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jan 12, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Jan 05, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Hello,

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.

System Specs:
OS: Windows 7 Premium 64-bit
RAM: 16GB

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

Desired Skills
MySQL Administration, Database
Job ID: 22501323
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Pakistan  |  
Al-Bari Consulting is a group of professional with expert level in domain. We provide software development and support services for mission...
1
  |  
 4.6   |  $90 Earnings   |  1 Jobs
Bid ID: 22567684  |  Submitted: Jan 11, 2011 04:26 ET 
Proposal SEALED

 Romania  |  
I'm a 23 years old programmer. i have more than 5 years experience in this area of activity. I'm working with PHP5, MySQL, Oracle, PostgreSQL,...
1
  |  
 5.0   |  $50 Earnings   |  1 Jobs
Bid ID: 22561025  |  Submitted: Jan 10, 2011 16:55 ET 
Proposal SEALED

 Greece
We are a software company which aims on Web technologies. MySQL, SQL-Server, Python, Twisted, PHP, Perl, Joomla, Drupal, zenCart are a few of the...
1
  |  
 4.7   |  $200 Earnings   |  0 Jobs
Bid ID: 22518340  |  Submitted: Jan 6, 2011 21:09 ET 
Proposal SEALED

 United States  |  
Winner
todo
1
  |  
 5.0   |  $600 Earnings   |  1 Jobs
Bid ID: 22513003  |  Submitted: Jan 6, 2011 12:38 ET 
Delivery
Within 1 day
$100.00

 United States
I have 15 years experience with 10+ languages and design skills along with system/network administration, database design and administration and...
1
  |  
 5.0   |  $0 Earnings   |  1 Jobs
Bid ID: 22506041  |  Submitted: Jan 6, 2011 01:57 ET 
Proposal SEALED

 United States  |  
IDS has been developing focused, web based applications since 1994. Our forte is rapid application development. Timelines run days, not weeks or...
8
  |  
 5.0   |  $45,336 Earnings   |  5 Jobs
Bid ID: 22503407  |  Submitted: Jan 5, 2011 21:39 ET 
Proposal SEALED

 United States  |  
20 years experienced DBA in Oracle and Mysql
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 22502492  |  Submitted: Jan 5, 2011 19:31 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »