I've seen whitepapers from MySQL's web site, co-authored with Dell, that recommend the hardware optimization be:
1. More Memory 2. Faster Drives (15K RPM is better the 10K) 3. Faster CPU. Based on this, we're spec'ing 2950s with 16Gb, dual 2.8 dual-core Xeons, and 146Gb 15K (times 6) drives. The plan is to RAID then 2 x RAID1 for the o/s (/boot, /, /var, and some working space for dumps and restores), and 4 x RAID10 for /data. Anyone have any feedback on this? Tim > -----Original Message----- > From: Chris White [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 12, 2006 3:59 PM > To: mysql@lists.mysql.com > Subject: Re: I don't understand why SCSI is preferred. > > On Tuesday 11 July 2006 04:18 pm, Brian Dunning wrote: > > My understanding is that SCSI has a faster transfer rate, for > > transferring large files. A busy database needs really fast access, > > for making numerous fast calls all over the disk. Two different, > > unrelated things. > > > > I am more than willing to be called Wrong, slapped, and cast from a > > bridge. > > Hmm, not sure if the question at hand is being answered. The topics I've > seen > so far seem to indicate why SCSI is fast. However, the original question > was > more along the lines of "Does it matter with regards to database > performance?". From what I know of MySQL, not really, because MySQL does > a > good amount of work in memory. The only time I'd see disk access being a > factor is if you had a large mass of swap/virtual memory. > > Now one place where I'm sure it would matter is if you were doing a > substantial amount of logging, or db dumping to disk. Then yes, you'd > want a > nice fast disk at that point. > > -- > Chris White > PHP Programmer/DBlowMeAway > Interfuel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]