http://blogs.sun.com/roch/entry/zfs_and_oltp ____________________________________________________________________________________ Performance, Availability & Architecture Engineering Roch Bourbonnais Sun Microsystems, Icnc-Grenoble Senior Performance Analyst 180, Avenue De L''Europe, 38330, Montbonnot Saint Martin, France Roch.Bourbonnais at Sun.Com (+33).4.76.18.83.20
On Fri, Sep 22, 2006 at 03:38:05PM +0200, Roch wrote:> > > http://blogs.sun.com/roch/entry/zfs_and_oltpAfter reading this page and taking into consideration my (not so big) knowledge of ZFS it came to my mind that putting e.g. Oracle on both UFS+DIO _and_ ZFS would be the best solution _at_the_moment_. E.g redo logs and undo tablespace on ZFS (because its COW nature so that all writes to these files will go with full speed) and all the rest database files on UFS+DIO. What do you think ? przemol
przemolicc at poczta.fm writes: > On Fri, Sep 22, 2006 at 03:38:05PM +0200, Roch wrote: > > > > > > http://blogs.sun.com/roch/entry/zfs_and_oltp > > After reading this page and taking into consideration my (not so big) knowledge > of ZFS it came to my mind that putting e.g. Oracle on both UFS+DIO _and_ > ZFS would be the best solution _at_the_moment_. E.g redo logs and undo > tablespace on ZFS (because its COW nature so that all writes to these > files will go with full speed) and all the rest database files on UFS+DIO. > > What do you think ? > You may gain some perf _today_ by using UFS/DIO at the expense of integrity/availability/ease of use. That would be the tradeoff. It''s also given that mileage will vary. -r > przemol > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
We did an experiment where we placed the logs on UFS+DIO and the rest on ZFS. This was a write heavy benchmark. We did not see much gain in performance by doing that (around 5%). I suspect you would be willing to trade 5% for all the benefits of ZFS. Moreover this penalty is for the current version, ZFS can/will get much faster. -neel przemolicc at poczta.fm wrote:> On Fri, Sep 22, 2006 at 03:38:05PM +0200, Roch wrote: >> >> http://blogs.sun.com/roch/entry/zfs_and_oltp > > After reading this page and taking into consideration my (not so big) knowledge > of ZFS it came to my mind that putting e.g. Oracle on both UFS+DIO _and_ > ZFS would be the best solution _at_the_moment_. E.g redo logs and undo > tablespace on ZFS (because its COW nature so that all writes to these > files will go with full speed) and all the rest database files on UFS+DIO. > > What do you think ? > > przemol > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
On Mon, Sep 25, 2006 at 08:37:23AM -0700, Neelakanth Nadgir wrote:> We did an experiment where we placed the logs on UFS+DIO and the > rest on ZFS. This was a write heavy benchmark. We did not see > much gain in performance by doing that (around 5%). I suspect > you would be willing to trade 5% for all the benefits of ZFS. > Moreover this penalty is for the current version, ZFS can/will > get much faster. > -neelNeel, I thought of the other solution: the logs on ZFS and rest on UFS+DIO. I suspect that writes on ZFS are faster then on UFS+DIO (in OLTP environment). przemol