[zfs-discuss] DBMS on zpool
Hi Just playing around with zfs , trying to locate DBMS data files to zpool. DBMS i mean here are oracle and informix. currently noticed that read operations perfomance is excelent but all write operations are not and also write operations performance variates a lot. My quess for not so good write performance and write performance variation is double buffering , DBMS buffers and zfs caching. together. Have anyone seen or tested best practices how should DBMS setup be implemented using zpool ; zfs or zvol. Thanks This message posted from opensolaris.org ___ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
RE: [zfs-discuss] DBMS on zpool
This is probably a good place to start. http://blogs.sun.com/realneel/entry/zfs_and_databases Please post back to the group with your results, I'm sure many of us are interested. Thanks, -- MikeE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of homerun Sent: Friday, May 18, 2007 8:42 AM To: zfs-discuss@opensolaris.org Subject: [zfs-discuss] DBMS on zpool Hi Just playing around with zfs , trying to locate DBMS data files to zpool. DBMS i mean here are oracle and informix. currently noticed that read operations perfomance is excelent but all write operations are not and also write operations performance variates a lot. My quess for not so good write performance and write performance variation is double buffering , DBMS buffers and zfs caching. together. Have anyone seen or tested best practices how should DBMS setup be implemented using zpool ; zfs or zvol. Thanks This message posted from opensolaris.org ___ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss ___ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
Re: [zfs-discuss] DBMS on zpool
homerun wrote: Hi Just playing around with zfs , trying to locate DBMS data files to zpool. DBMS i mean here are oracle and informix. currently noticed that read operations perfomance is excelent but all write operations are not and also write operations performance variates a lot. My quess for not so good write performance and write performance variation is double buffering , DBMS buffers and zfs caching. together. Have anyone seen or tested best practices how should DBMS setup be implemented using zpool ; zfs or zvol. Neel has spent some time on this topic. I'd start with his blog. http://blogs.sun.com/realneel Additional blogs to check are Roch's and Bob Sneed, for discussions on caching and direct I/O. http://blogs.sun.com/roch http://blogs.sun.com/bobs We've been trying to collect the wisdom onto one site, but it is getting a little crowded and therefore tends to be terse. The blogs explain the concepts in more detail, and more conversationally. http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide -- richard ___ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss