RAID-5 is cool, RAID-1+0 (10) is better for writes. Your defiantly are going to be IO bound. I would go with many smaller disks >= 20 disk, in multiple RAID-1+0 configurations on different channels or better yet different RAID controllers.
Reason by example: Sun T3 with 7 drives. I'm IO bound with a read heavy 2 Gb where most of the data is in memory. I'm transferring 15Mb a second of read traffic. -->-----Original Message----- -->From: Mysql List [mailto:[EMAIL PROTECTED] -->Sent: Thursday, July 24, 2003 10:16 AM -->To: [EMAIL PROTECTED] -->Subject: Re: Huge Server configuration --> -->Dathan Vance Pattishall wrote: --> -->>NICE -->> -->>No matter how big your disks are, the number of spindles and throughput -->>is your win. -->> -->> -->I have RAID 5 with 5 hardisks, so usuable number of spindle will only be -->4. --> -->>my.cnf 3.5x options -->> -->>skip-locking -->>skip-name-resolve -->> -->>set-variable = tmp_table_size=4096 -->>log-bin=binlog/something make sure binlog is a symlink to a separate -->>partition / drive -->> -->>set-variable = key_buffer=4G -->>set-variable = table_cache=2600 # make sure your OS can handle *2 this -->>many file descriptors -->>set-variable = sort_buffer=512M # this is not a common mem pool but a -->>thread pool -->>set-variable = record_buffer=512M -->>set-variable = record_rnd_buffer=512M -->>set-variable = myisam_sort_buffer_size=512M -->>set-variable = max_allowed_packet=16M -->> -->> -->> -->> -->>-->-----Original Message----- -->>-->From: Mysql List [mailto:[EMAIL PROTECTED] -->>-->Sent: Thursday, July 24, 2003 9:38 AM -->>-->To: [EMAIL PROTECTED] -->>-->Subject: Huge Server configuration -->>--> -->>-->Hello all, -->>--> -->>-->I have a server like 8way Intel Pentium 4 Xeon processor with 12GB -->>RAM -->>-->and 1TB harddisk space. -->>-->All the tables size are over 10GB and they have over 100mm records. -->>--> -->>-->Could some one help me get an appropriate mysql -->>configuration(my.conf) -->>-->file for the machine. -->>--> -->>-->I understand ther are lots of factors depends on it to get a steady -->>-->working configuration. -->>-->All I need is some model configuration. I think later on I can tune -->>thar -->>-->up. -->>--> -->>-->Thanx in Advance -->>-->-Chandra -->>--> -->>--> -->>--> -->>--> -->>-->-- -->>-->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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
