Project Detail

MySQL my.conf tweaking for production server  

MySQL my.conf tweaking for production server is project number 506996
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: itamarjp

Budget: $30-250

Created: 09/12/2009 at 15:30 EDT

Bid Count: 20

Average Bid:
$ 76

09/22/2009 at 15:30 EDT

Project Creator: whssf
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (10 reviews)

Bid On This Project
 

Description

I need to run a mysql server on a fairly big machine,
it has 64GB ram, and two quad processors.
The DB files are stored in the same server.

Runs on Ubuntu 9.10 64bits

MySQL is not the only one process,
the server also runs a memory hungry Ruby on Rails app.

Tweaking queries is not an option,
I am only requesting the best mysql conf possible for this scenario.

I am using InnoDB tables,
and want to configure MySQL to be as fast possible and to make use of as many memory caches as possible from the configuration itself.

The systems has many read-writes even per each request,
there are all relatively small in therms of size,
although it writes once every hundred reads.

The web system doesn't have many requests per second,
but each request tends to be a heavy one.

Probably although they could be about 100 users logged in,
no more than 60 requests will be sent during the same minute.

You have to provide a very well tweaked my.conf file for mysql to make best/full use of the machine resources,
with comments explaining each of the settings,
and why not an alternative to each.


Thank you,

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

80

3 days

09-14-2009 04:06 EDT

Hi. That's my specialty. Please check PM.

help

 

100

3 days

09-12-2009 18:32 EDT

can do this fro u. escrow to start. also i need info about hardware: cpu count, disk subsystem. and how much memory use ur R&R, + overal size of db data.

help

 

100

1 day

09-12-2009 19:38 EDT

I am expert on LAMP and can do this easily, please see PM

help

 

250

20 days

09-12-2009 20:42 EDT

It can be done :)

help

 

100

2 days

09-13-2009 10:23 EDT

Please check your PMB. Thank you.

help

 

75

1 day

09-12-2009 21:11 EDT

I have done optimizations for several high traffic websites. I will be sure you are running at an optimal performance level. Thanks for considering me! -Rick

help

 

30

0 days

09-12-2009 19:49 EDT

I am a fedora/centos Linux developer and mysql expert, I can do this for you and make your mysql running light and faster.

help

 

60

1 day

09-17-2009 07:57 EDT

Expert Computer Engineer, Having experience in MYsql , Can Start Work on Immediately effect.

help

 

50

5 days

09-15-2009 15:33 EDT

Hello, I am an experienced mysql sysadmin. To get a good my.cnf file I have to look at some statistics mysql collect during the use. Based on this result, my.cnf is tweaked accordingly. If you can grant me full access to your system, I can grant you the best result. I am from Italy, GMT+1

help

 

70

2 days

09-13-2009 10:40 EDT

Hy! I have extensive experience managing mysql servers (both innodb and myisam engines). Please check your PMB for more details. Cheers!

help

 

80

2 days

09-13-2009 00:15 EDT

I am currently managing 500+ linux Servers, I am managing 70 Mysql Server, each server having 8 core CPUs XEON, and 16GB RAM.. Some time back i had the same problem, then i Tunned up both Mysql Server configurations (my.cnf) and Queries. I will provide you quick, reliable and standing services.

help

 

50

4 days

09-12-2009 20:07 EDT

(No Feedback Yet)

Hi, I am a mysql expert, i can get it done this thing for you.

help

 

30

0 days

09-13-2009 03:12 EDT

(No Feedback Yet)

Hi , I AM A MySQL DBA AND DEVELOPER WORKING WITH A MNC. i do this kind of configuration file tweaking for a lot of servers all linux based on a daily basis can do this work very efficiently . also i have knowledge of innodb related options too in mysql config regards

help

 

80

1 day

09-13-2009 18:04 EDT

(No Feedback Yet)

hi, please check PM for more details.

help

slk

 

50

1 day

09-14-2009 04:25 EDT

(No Feedback Yet)

Hello, I'm a network engineer with five experience of isp working. My reviews speak for me: http://www.scriptlance.com/cgi-bin/freelancers/feedback.cgi?p=slk I hope you will choose me as your sysadmin.

help

 

120

3 days

09-18-2009 01:47 EDT

(No Feedback Yet)

Have direct experience with mySQL tuning for production web applications on 8-way 32Gb SAS servers. 10y LAMP experience, 3y LAMP administration in a strenuous 24x7 production environment. Proposal is 1d of stats collection, 1d of 'beta' tuning, 1d of 'final' tuning. 1 page writeup document will accompany configuration file, ongoing tuning available upon request (though shouldn't be needed :) Look forward to hearing from you - exited to work with you.

help

 

80

1 day

09-18-2009 08:54 EDT

(No Feedback Yet)

Hello, We will please to work on this project If you decided to assign this to us. We have hand on Web base technology. Looking for long term relationship. Hope both will benefit for this project.. Anticipation of positive response. Regards Fanatical Solution

help

 

30

1 day

09-18-2009 12:07 EDT

(No Feedback Yet)

I have some general ideas on improving performance, but fine tuning would require access to a mysql prompt, or perhaps Phpmyadmin to get performance stats.

help

 

60

2 days

09-18-2009 12:11 EDT

(No Feedback Yet)

I have an over 7 years of experience in linux system administration and web development (LAMP). At my main job I have many experience with 2-tier LAMP highload systems set up and maintenance. All highload systems was stress tested before running to production. Please review my profile. I will wait for you decision. Thank You

help

 

30

0 days

09-22-2009 05:50 EDT

(No Feedback Yet)

Hi currently managing number of Mysql Server on 16 GB RAM serving fast request. Database expert (DBA), DB tunning is specialty.

help


    Bid on this Project