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
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
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: zfs-discuss-bounces at opensolaris.org [mailto:zfs-discuss-bounces at opensolaris.org] On Behalf Of homerun Sent: Friday, May 18, 2007 8:42 AM To: zfs-discuss at 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 at opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss