176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

My SQL optimization and troubleshooting.
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.

May 10, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, May 08, 2012
  • 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

Our site has a MySQL database with 156 tables. When I check the status tab in phpMyAdmin, I see a number of issues pertaining to the past 60 days of activity. For example: 12.8K Slow queries, 900M Handler_read_rnd_next indicating a lot of table scans that maybe caused by lack of indexes,4M queries that have been removed from the cache to free up memory for caching new queries, 973 Slow_launch_threads, 131 Delayed_errors, 289k Select_full_join. We like to have these issues reviewed and fixed if significant.

Sign in or Register to see more

Desired Skills
MySQL Administration, PHP
Job ID: 30403568
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
- Expertise in SQL Server and MySQL database design and development. - Highly specialized skills in all data and database related issues. - We can...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30433143  |  Submitted: May 9, 2012 19:15 ET 
Proposal SEALED

William R.      
William R.'s identity has been verified.  Learn More
 United States  |  
Winner
I am an expert-level MySQL Database Engineer, currently employed full time as such at Yahoo. In my past, I have done similar work for other major...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30409849  |  Submitted: May 9, 2012 00:05 ET 
$65.75/hr
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 »