Re: [zones-discuss] zones databases
Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK With the performance boosts included in recent solaris versions I'm BK told that there's not much of a difference between handing the database BK raw devices vs. using a filesystem anymore. BK To test this out, my customer would like to try both ufs and vxfs BK filesystems in the global zone and lofs mount them to a local zone BK and test the database on that lofs mount. BK Are there any options that should be supplied for the lofs mount and BK are there any options for the ufs and/or vxfs mounts that should be BK employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones databases
Brian Kolaci wrote: Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK With the performance boosts included in recent solaris versions I'm BK told that there's not much of a difference between handing the database BK raw devices vs. using a filesystem anymore. BK To test this out, my customer would like to try both ufs and vxfs BK filesystems in the global zone and lofs mount them to a local zone BK and test the database on that lofs mount. BK Are there any options that should be supplied for the lofs mount and BK are there any options for the ufs and/or vxfs mounts that should be BK employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? Not an answer, just a clarification: LOFS essentially re-mounts an existing filesystem onto an additional mount-point. When using LOFS, there is always the original fs type to consider. The comparison would then be a LOFS-mount of a UFS filesystem vs. a UFS filesystem vs. a raw device. Of course, VxFS can be substituted for UFS. -- -- Jeff VICTOR Sun Microsystemsjeff.victor @ sun.com OS AmbassadorSr. Technical Specialist Solaris 10 Zones FAQ:http://www.opensolaris.org/os/community/zones/faq -- ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones databases
Jeff Victor wrote: Brian Kolaci wrote: Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK With the performance boosts included in recent solaris versions I'm BK told that there's not much of a difference between handing the database BK raw devices vs. using a filesystem anymore. BK To test this out, my customer would like to try both ufs and vxfs BK filesystems in the global zone and lofs mount them to a local zone BK and test the database on that lofs mount. BK Are there any options that should be supplied for the lofs mount and BK are there any options for the ufs and/or vxfs mounts that should be BK employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? Not an answer, just a clarification: LOFS essentially re-mounts an existing filesystem onto an additional mount-point. When using LOFS, there is always the original fs type to consider. The comparison would then be a LOFS-mount of a UFS filesystem vs. a UFS filesystem vs. a raw device. Of course, VxFS can be substituted for UFS. I guess the direct question would be a LOFS-mount of a VxFS filesystem with QuickIO enabled. Typically databases want either QuickIO or forcedirectio (on UFS) enabled so that writes aren't buffered. Is that still the case if LOFS is mounted on another filesystem? The DBA's say that writing to a raw device is somewhat equivalent to writing a file on a filesystem with QuickIO enabled. ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones databases
On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK With the performance boosts included in recent solaris versions I'm BK told that there's not much of a difference between handing the database BK raw devices vs. using a filesystem anymore. BK To test this out, my customer would like to try both ufs and vxfs BK filesystems in the global zone and lofs mount them to a local zone BK and test the database on that lofs mount. BK Are there any options that should be supplied for the lofs mount and BK are there any options for the ufs and/or vxfs mounts that should be BK employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones databases
[EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK With the performance boosts included in recent solaris versions I'm BK told that there's not much of a difference between handing the database BK raw devices vs. using a filesystem anymore. BK To test this out, my customer would like to try both ufs and vxfs BK filesystems in the global zone and lofs mount them to a local zone BK and test the database on that lofs mount. BK Are there any options that should be supplied for the lofs mount and BK are there any options for the ufs and/or vxfs mounts that should be BK employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol ___ zones-discuss mailing list zones-discuss@opensolaris.org While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones databases
Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK With the performance boosts included in recent solaris versions I'm BK told that there's not much of a difference between handing the database BK raw devices vs. using a filesystem anymore. BK To test this out, my customer would like to try both ufs and vxfs BK filesystems in the global zone and lofs mount them to a local zone BK and test the database on that lofs mount. BK Are there any options that should be supplied for the lofs mount and BK are there any options for the ufs and/or vxfs mounts that should be BK employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone 2. with UFS mount with directio option, there's an equivalent for VxFS 3. ZFS could also be interesting with recordsize lowered to match db block size Have you got any results you can share yet? -- Best regards, Robertmailto:[EMAIL PROTECTED] http://milek.blogspot.com ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones databases
On Wed, 26 Jul 2006, Brian Kolaci wrote: To test this out, my customer would like to try both ufs and vxfs filesystems in the global zone and lofs mount them to a local zone and test the database on that lofs mount. I'd also recommend that your customer tries the tests on ZFS too. -- Rich Teer, SCNA, SCSA, OpenSolaris CAB member President, Rite Online Inc. Voice: +1 (250) 979-1638 URL: http://www.rite-group.com/rich ___ zones-discuss mailing list zones-discuss@opensolaris.org