MySQL Forums
Forum List  »  MySQL & Storage

Re: NTFS recommended allocation unit size
Posted by: Josh Chamas
Date: February 12, 2006 11:53PM

Gary Wilson wrote:
> Further to this, how do I determine the optimum
> stripe size to set my RAID 1+0 on??? This seems
> to be quite a dark art....
>
> Regards
> Gary


Hi Gary,

To really know, you need a benchmark, and try it out.

For cluster size, generally larger cluster are bettter for larger files. For large
MyISAM tables and InnoDB tablespace, larger cluster unit size for NTFS from 4K-64K
would be good to try.

Also, make sure your RAID stripe size is large, generally
the larger the better, 64K+ is often good.

But, all the expert advice in the world will not beat a benchmark
relevant to your application that you run yourself. So try things and
test away!

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Written By
Posted
Re: NTFS recommended allocation unit size
February 12, 2006 11:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.