> As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would > _highly_ recommend a journaling filesystem such as Reiserfs > (http://www.namesys.com) or XFS (http://oss.sgi.com). I've used reiserfs for > a long time, but XFS is growing on me. It seems to be more stable in latest > 2.4 kernels.
I don't know the reason for this. I'd refer people to http://www.linuxjournal.com//article.php?sid=5840 Although that article talks about Oracle, we also found ext3 for mysql data disks to be the best choice from our own experience. Reiserfs jams with lots of small files though; useful when compiling (mysql source for example) or for a webserver. Actually, I like it for everything but the mysql data dir. > Is it better to take Raid level 1 or 0 ? RAID 0 or RAID 0+1 with a lot of disks makes a huge speed difference under load. SQL server speed (trx/s) can correlate to the rotational speed of the disks once the server is disk bound. RAID 0 lets you increase the effective speed of the virtual drive by summing the speed of the disks (roughly). I have no experience with IDE RAID though. SCSI still outperforms and likely always will. Sincerely, Steven Roussey http://Network54.com/?pp=e sql, query --------------------------------------------------------------------- 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