Completed

MySQL fine tweaking for performance

This project was successfully completed by pauljacionis for $53 USD in 7 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
7 days
Total Bids
4
Project Description

Hi,

I Need to tweak a production MySQL database.

There are no slow queries, all searching fields are indexed, etc, etc.

But...

These servers run on a dedicated Ubuntu Virtual Machines with about 12 GB or ram, and can use up to 4 cores.
and are only using about 3GB, so I need to improve the caching,
the only service running on the VM is the MySQL database.

I can give you the current configuration files and any info you want,
but cannot give you access to the servers in any way.

You'll need to provide me conf files to optimize the performance with the current resources.

The server runs reading 98% and writing 2%

The DB needs to serve a pool of 20 Rails unicorn workers.


Please, bid only if you know what we are talking about, and been there done that.


Thank you,

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online