suggestion for disk configuration

2008-01-24 Thread Luca Ferrari
Hi, I have to install a mysql server for managing several database, from small to quite big (tables with about 2M rows). I've got a SAS disk array and I was wondering what the best configuration could be: 1) raid 10 2) raid 5 3) a combination (e.g., raid10 for the data and raid 5 for the logs).

Re: suggestion for disk configuration

2008-01-24 Thread B. Keith Murphy
Luca, In my testing I have had better throughput with RAID 10 (at least with XFS). I have not worried about the log files so much, so you might want to investigate that some. I would love to see benchmarks of your SAS array though. If you have a blog you should publish them if at all