sun818 - 9:32 pm on Feb 22, 2005 (gmt 0)

You may want to add a third hard disk and go for RAID 0+1: [dev.mysql.com...]

Your mirrored suggestion will provide better read performance, but the bottle neck tends to be in writing. If you don't want to opt for the third drive, partition the drive and keep the tables separate from the indexes and rollback segments. That way, there is less disk contention.

For server use, I'd stick with SATA since it has command queuing: [seagate.com...] - that's what SCSI was good for too.