Käynnissä

MySQL [url removed, login to view] tweaking for production server

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 [url removed, login to view] 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,

Taidot: Linux, SQL, Järjestelmänvalvoja

Näytä lisää: memory conf, production server, mysql production, mysql server 64bits, tweaking mysql server, ubuntu ruby on rails, server for ruby on rails, ruby on rails server, ruby on rails linux, ruby on rails app for server, resources ruby on rails, mysql production configuration, mysql configuration production server, ruby on rails mysql, tweaking, ruby linux, ram, mysql read files, read process memory, mysql comments, web app rails, rails web app, run ubuntu, system production, linux server files

Tietoa työnantajasta:
( 17 arvostelua ) Santa Fe, United States

Projektin tunnus: #506996

Myönnetty käyttäjälle:

itamarjp

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

30 $ USD 0 päivässä
(70 arvostelua)
5.6

20 freelancers are bidding on average $76 for this job

meral

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.

100 $ USD 3 päivässä
(104 arvostelua)
7.5
nknk

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

80 $ USD 3 päivässä
(203 arvostelua)
7.1
starshine

It can be done :)

250 $ USD 20 päivässä
(8 arvostelua)
5.9
Azoth

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

100 $ USD 1 päivässä
(26 arvostelua)
5.7
codetrance

Please check your PMB. Thank you.

100 $ USD 2 päivässä
(70 arvostelua)
5.5
slk

Hello, I'm a network engineer with five experience of isp working. My reviews speak for me: [url removed, login to view] I hope you will choose me as your sysadmin.

50 $ USD 1 päivässä
(14 arvostelua)
4.6
leandrodardini

Hello, I am an experienced mysql sysadmin. To get a good [url removed, login to view] file I have to look at some statistics mysql collect during the use. Based on this result, [url removed, login to view] is tweaked accordingly. If you can grant me full access Lisää

50 $ USD 5 päivässä
(15 arvostelua)
4.5
RickMc

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

75 $ USD 1 päivässä
(21 arvostelua)
4.5
bastardangel

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

70 $ USD 2 päivässä
(14 arvostelua)
4.2
gr8Ideas

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 (m Lisää

80 $ USD 2 päivässä
(10 arvostelua)
4.0
YashpalSingh123

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

60 $ USD 1 päivässä
(3 arvostelua)
3.5
dewed

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.

30 $ USD 1 päivässä
(3 arvostelua)
2.8
fanaticals

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 o Lisää

80 $ USD 1 päivässä
(0 arvostelua)
0.0
asukhov

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 s Lisää

60 $ USD 2 päivässä
(0 arvostelua)
0.0
linuxexperts

hi, please check PM for more details.

80 $ USD 1 päivässä
(0 arvostelua)
0.0
ct199

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 collec Lisää

120 $ USD 3 päivässä
(0 arvostelua)
0.0
puthranroshan07

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 Lisää

30 $ USD 0 päivässä
(0 arvostelua)
0.0
reeshi

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

50 $ USD 4 päivässä
(0 arvostelua)
0.0
gurusingh

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

30 $ USD 0 päivässä
(0 arvostelua)
0.0