Need data on disk drive management by OS: getting base I/O unit size, "sync" option, Direct Memory A

Posted by Richard T on Server Fault See other posts from Server Fault or by Richard T
Published on 2010-03-31T21:25:10Z Indexed on 2010/03/31 21:33 UTC
Read the original article Hit count: 382

Filed under:
|
|
|

Hello All,

I want to ensure I have done all I can to configure a system's disks for serious database use. The three areas I know of (any others?) to be concerned about are:

  1. I/O size: the database engine and disk's native size should either match, or the database's native I/O size should be a multiple of the disk's native I/O size.
  2. Disks that are capable of Direct Memory Access (eg. IDE) should be configured for it.
  3. When a disk says it has written data persistently, it must be so! No keeping it in cache and lying about it.

I have been looking for information on how to ensure these are so for CENTOS and Ubuntu, but can't seem to find anything at all!

I want to be able to check these things and change them if needed.

Any and all input appreciated.

© Server Fault or respective owner

Related posts about database

Related posts about disk