Thomas S. Iversen wrote: > Back to the question: we're on a limited budget, and have to choose > between either inexpensive but large IDE disk or fast but small SCSI > disks. The machine has 1GB memory. First thought would be IDE disks since > we have enough memory to cache the DBs.
If you're on a budget, check out some of the IDE RAID options. You can build a RAID 0 using a fairly cheap card (I would have suggested a MB with RAID 0, but you probably already have one without). Promise's SuperTrak SX 6000 will also do RAID 0, 1, 0+1, 3, 5 and JBOD on six disks with up to 128 MB cache (you buy one $20 SDRAM chip), but it is a bit pricier at ~$450. You can save your money by getting multiple <$100 IDE drives. Do NOT get the SuperTrak 100, it is almost as slow as one drive in RAID 5. Anyone actually have experience running MySQL on a large-ish IDE RAID? Frank. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php