176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Innodb (MySQL) Performance Tuning of Writes
Sign in to Add to Watch List

IT & Programming > Database Administration

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jul 22, 2014

Job awarded.

Jul 18, 2014
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Jul 14, 2014
  • 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
  • Hourly Rate: Not Sure
  • Hrs/wk: Not Sure | Duration: Not Sure
  • Work View™ Payment Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We are looking for an expert MySQL DBA to help us tune both our table, server, and queries to maximize performance of this mission-critical part of our application. Our troubles stem from a single table. It houses the main data for our application, has many millions of rows and is using the InnoDB storage engine on an m3.large AWS RDS Instance.

We are constantly collecting data from our real-time data sources. Whenever we receive new data for a location, we mark existing data in this table as being stale (e.g, UPDATE table SET stale = 1 WHERE location_id = 123). We then perform several thousand inserts to save the new data which has stale set to 0. When visitors use our application, we fetch this data out of this table and display to them the latest (SELECT * FROM table WHERE location_id = 123 and stale = 0). The reads from this table all function very well.

The problem is related to processes that we run to collect data from all of the locations. When we have just a single...

Sign in or Register to see more

Job ID: 59509460
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
4iSoft has been at the forefront of onsite and remote database administration, serving some of the most illustrious (and demanding) clients. The...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 60114752  |  Submitted: Jul 28, 2014 10:04 ET 
Proposal SEALED

Mysql,Sql DBA 5+ yrs exp: - Have experience of designing relational database for large user traffic. - Expertise in optimizing mysql database by...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 59692196  |  Submitted: Jul 18, 2014 05:59 ET 
Proposal SEALED

 Indonesia  |  
Winner
Professional system administrator and developer specialized in web performance optimization / tuning, high traffic website, server optimization,...
9
  |  
 4.9   |  Private   |  15 Jobs
Bid ID: 59551259  |  Submitted: Jul 15, 2014 11:34 ET 
$50.00/hr

 India  |  
INVITED
MySQL DBA with an experience of 8 plus years in MySQL. Having a core knowledge of Database and Operating system. Expert in trouble shooting MySQL...
4
  |  
 4.8   |  Private   |  34 Jobs
Bid ID: 59525434  |  Submitted: Jul 15, 2014 00:56 ET 
Proposal SEALED

Aman Aggarwal      
Aman Aggarwal's identity has been verified.  Learn More
 India  |  
DBA having 5+ year of experience. Experience in Database designing, development, Parameter configuration, server tuning according to server...
2
  |  
 4.3   |  Private   |  73 Jobs
Bid ID: 59520172  |  Submitted: Jul 14, 2014 21:24 ET 
Proposal SEALED

Majid K.      
Majid K.'s identity has been verified.  Learn More
 Finland  |  
INVITED
Certified(OCP) DBA Oracle 9i, 10g, 11g and Mysql 5. I have a decade long experience with databases and data handling and like to work on data...
4
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 59513484  |  Submitted: Jul 14, 2014 17:00 ET 
Proposal SEALED

 Russia  |  
My goal is customer satisfaction. If you need to get something done - leave it to me. OS: Linux - expert, FreeBSD and Windows Server - proficient...
7
  |  
 4.9   |  $3,607 Earnings   |  18 Jobs
Bid ID: 59511582  |  Submitted: Jul 14, 2014 16:07 ET 
Proposal SEALED

 China  |  
Dear Clients, I am a senior web developer. Over the last 12 years, I have worked extensively on PHP website development utilizing several...
8
  |  
 5.0   |  Private   |  15 Jobs
Bid ID: 59511125  |  Submitted: Jul 14, 2014 15:55 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 »