In Progress

MySQL fine tweaking for performance

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,

Here's the my.cnf file attached, as pasting doesn't keep format,

Skills: Database Administration, MySQL

See more: ubuntu service, database caching, virtual workers, searching for workers, tweaking, optimize mysql, fine, database performance , mysql caching, mysql server performance, slow queries, mysql production, improve performance, tweaking access, mysql slow queries, improve current database, mysql slow, rails service, dedicated server ram, virtual administration, performance optimize, reading database, ubuntu configuration, mysql administration, dedicated mysql

About the Employer:
( 17 reviews ) Santa Fe, United States

Project ID: #4464207

Awarded to:

pauljacionis

8 years experience of working with MySQL

$53 USD in 7 days
(5 Reviews)
5.2

3 freelancers are bidding on average $102 for this job

farhaoui

Hello, I'm ready to help you to optimize your Mysql Server.

$52 USD in 3 days
(12 Reviews)
4.1
GandalfTheGrey

I am an experienced Linux and database administrator. More details sent privately.

$210 USD in 3 days
(6 Reviews)
4.1
allbert

I can optimize your DB and webserver . check pm

$154 USD in 3 days
(0 Reviews)
0.0
SunnyDev

I can help you, see PM.

$44 USD in 3 days
(0 Reviews)
0.0