I like using either raid 0+1.. it really cooks, or if you can'y spare the disks, raid 1 ... Something pushing that many queries, should probably be protected from disk failure.
On Wed, 20 Aug 2003, Jackson Miller wrote: > I am setting up a dedicated MySQL server with some pretty heavy usage. I am > not much of a sys admin (mostly a programmer). I have some questions about > the best drive configuration. > > I have 4 SCSI drives currently. > > I would like to have 1 drive run the OS, > 1 drive to be the MySQL data directory > and 1 drive to be InnoDB (possibly raw partition). > > What is the best way for me to configure RAID? > > Here is the kind of load I am talking about: > Uptime: 1749850 Threads: 44 Questions: 1266402021 Slow queries: 16923 > Opens: 162177 Flush tables: 1 Open tables: 64 Queries per second avg: > 723.720 > > Thanks, > -Jackson > > > > > -- > jackson miller > > cold feet creative > 615.321.3300 / 800.595.4401 > [EMAIL PROTECTED] > > > cold feet presents Emma > the world's easiest email marketing > Learn more @ http://www.myemma.com > > -- > 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]
