G
gus bjorklund
Guest
Generally, a database block size that is a multiple of the filesystem blocksize (e.g 8k and 4k) will work rather well. The opposite is NOT true thpugh. Filesystems can read and write two contiguous blocks to disk in almost the same time as writing one block. Yes, there is a small possibility that two filesystem blocks that make up one database block will NOT be contiguous. This is a rare event and while possible, hardly ever occurs unless the filesystem is 80% or more full mostly of lots of small files. On the other hand, the difference between 8k and 4k database blocks is not very much. i confess it has been some time ago that i tested that.
Continue reading...
Continue reading...