tunables and settings for IDS 11.5 on a ZFS file

Anyone have knowledge of how I should set OS tunables or any other settings(variables, ZFS files system settings) for a new installation of 11.5 on a Solaris 10 zone, with the Informix instance(about 4TB in size) residing on a cooked ZFS file system? I'm having trouble getting anything concrete for any important settings. Is there any way the cooked files should be laid out for I/O performance? Any particular block size, etc? Thanks!

Do you want to use a ZFS, AFAIK you can not turn off logging, and its not that quick compared to 'standard' FS. You might want to benchmark with a 'standard' FS Cheers Paul > Anyone have knowledge of how I should set OS tunables or any other > settings(variables, ZFS files system settings) for a new installation of > 11.5 > on a Solaris 10 zone, with the Informix instance(about 4TB in size) > residing > on a cooked ZFS file system? I'm having trouble getting anything concrete > for > any important settings. Is there any way the cooked files should be laid > out > for I/O performance? Any particular block size, etc? > > Thanks! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

ZFS filesystems are a bad choice for database. Here's an excerpt from my presentation on storage at the IIUG Conference in 2012: ZFS – Sun developed for Solaris and released as open source – Uses copy-on-write transaction model – rewrites are made to a different physical location than data came from and the new block replaces the old one in the meta-data. This causes chunks to become more and more non-contiguous (ie fragmented) over time even though the engine thinks the file is contiguous. – IDS pages are substantially smaller than ZFS pages. That means many rewrites of the same ZFS page and many relocations that have to be cleaned up in the background. Not as bad as some journaled filesystems, but not good. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 26, 2013 at 5:16 PM, MARK UNDERWOOD <munderwood786@gmail.com>wrote: > Anyone have knowledge of how I should set OS tunables or any other > settings(variables, ZFS files system settings) for a new installation of > 11.5 > on a Solaris 10 zone, with the Informix instance(about 4TB in size) > residing > on a cooked ZFS file system? I'm having trouble getting anything concrete > for > any important settings. Is there any way the cooked files should be laid > out > for I/O performance? Any particular block size, etc? > > Thanks! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34edeea9dcd04ec1bf6f5