MySQL Forums
Forum List  »  MySQL & Storage

Re: NTFS recommended allocation unit size
Posted by: Peter Zaitsev
Date: April 13, 2006 06:31PM

Hi,

What you're speaking is file block size. If you're only using MySQL on this drive you should be good with some lage value. The page size for Innodb is 16K and the tablespace file is large so there is not need for smaller value.

I would possibly even go with larger one but I'd bechmark it to be certain.
There are two things to consider

1) Does NTFS has to read full blocks. I do not know. On Linux some file systems would have some can read part of the block.

2) What it is internally optimized for ? Sometimes there are unexpected surprises out where.

Also in your setup you could benefit from placing some logs on your OS drive, as I guess it will be idle otherwise. If you RAID has backed up cache do not place Innodb logs on software RAID but Binary logs will do well.

Options: ReplyQuote


Subject
Written By
Posted
Re: NTFS recommended allocation unit size
April 13, 2006 06:31PM


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.