Difference between revisions of "Veritas vxfs filesystem performance"
From SybaseWiki
| 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 11: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.
Note: the graphs will be posted April 28, 2007.
