There's no such thing as a generic my.cnf for high performance MySQL servers, you will need to provide more information..
Some questions: Are you going to run InnoDB or MyISAM or both (if both, what's the split?) Is there anything else running on that server? i.e. how much of the 16GB is available for MySQL to use? Can you partition your disks as you wish? (How much data do you need host?) Will this server be a master or slave or standalone? (Do we need to deal with binlogs here?) Andrew -----Original Message----- From: Craig Dunn [mailto:li...@codenation.net] Sent: 06 May 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 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 disks, 16G RAM, 2 x dual > core 3000mhz 64bit... which is reasonably beefy. Environment is more > read than write, but write speed is important. > > Anyone know where I can look? > Cheers > Craig > > I should add, I wanted something a bit more up to date than my-huge.cnf, which seems to think a "huge server" is a "system with memory of 1G-2G" -- Linux web infrastructure consulting, cr...@codenation.net Free live poker tournament listings, http://www.g5poker.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.braithwa...@lovefilm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
