Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread mos
At 07:56 AM 5/6/2009, you wrote: Hi All, We're setting up a group of servers using MySQL Enterprise 5.1 - Rather than starting with a blank canvas I wondered if there was a suitable my.cnf that is tuned to the kind of environment I'm running where I can tweak it from there. We're running

Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Andrew Braithwaite wrote: Your disk config is good and you'll need all the nessesary my.cnf entries to point all the logs and data to the correct place. Slaves should have the relay-logs going to the OS disk too. I assume you've set up the master slave config in the my.cnf too. Yeah the repl

RE: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Andrew Braithwaite
li...@codenation.net] Sent: 06 May 2009 14:31 To: Andrew Braithwaite Cc: mysql@lists.mysql.com Subject: Re: Default my.cnf for (very) high performance servers Andrew Braithwaite wrote: > There's no such thing as a generic my.cnf for high performance MySQL > servers, you will need

Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Andrew Braithwaite wrote: There's no such thing as a generic my.cnf for high performance MySQL servers, you will need to provide more information.. Well, I was more after something a bit more up to date than my-huge.cnf that I could use as a starting point, I see a few example ones posted to

RE: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Andrew Braithwaite
ay 2009 14:02 To: mysql@lists.mysql.com Subject: Re: Default my.cnf for (very) high performance servers Craig Dunn wrote: > > > > Hi All, > > We're setting up a group of servers using MySQL Enterprise 5.1 - Rather > than starting with a blank canvas I wondered if

Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Craig Dunn wrote: Hi All, We're setting up a group of servers using MySQL Enterprise 5.1 - Rather than starting with a blank canvas I wondered if there was a suitable my.cnf that is tuned to the kind of environment I'm running where I can tweak it from there. We're running on RHEL, on Su

Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Hi All, We're setting up a group of servers using MySQL Enterprise 5.1 - Rather than starting with a blank canvas I wondered if there was a suitable my.cnf that is tuned to the kind of environment I'm running where I can tweak it from there. We're running on RHEL, on Sunfire X4140's - 8 d