Difference between revisions of "Veritas vxfs filesystem performance"

From SybaseWiki
Jump to: navigation, search
 
Line 12: Line 12:
  
 
Note: the graphs will be posted April 28, 2007.
 
Note: the graphs will be posted April 28, 2007.
 +
 +
[[Category:ASE]]

Revision as of 10:52, 27 April 2007

In an attempt to use the direct I/O feature of Sybase ASE 15 on a Veritas filesystem I ran into a couple of issues. It seems that direct i/o is not possible on this type of filesystem. You will see this in the errorlog:

Unable to open file in DIRECTIO_ON mode, error: (25) Inappropriate ioctl for device

To get the best performance I ran some tests with different mount options. A normal mount has these options set: read/write/nosuid/delaylog/largefiles/ioerror=mwdisable Additional mount options used in the test were: mincache=direct and convosync=direct

See below graphs for a quick overview of the resulting throughput.

File:Example.jpg

Note: the graphs will be posted April 28, 2007.