On Tue, Oct 02, 2007 at 01:20:24PM -0600, eric kustarz wrote: > > On Oct 2, 2007, at 1:11 PM, David Runyon wrote: > > > We are using MySQL, and love the idea of using zfs for this. We > > are used to using Direct I/O to bypass file system caching (let the > > DB do this). Does this exist for zfs? > > Not yet, see: > 6429855 Need way to tell ZFS that caching is a lost cause > > Is there a specific reason why you need to do the caching at the DB > level instead of the file system? I'm really curious as i've got > conflicting data on why people do this. If i get more data on real > reasons on why we shouldn't cache at the file system, then this could > get bumped up in my priority queue.
At least two reasons: http://developers.sun.com/solaris/articles/mysql_perf_tune.html#6 http://blogs.sun.com/glennf/entry/where_do_you_cache_oracle (the first example proofs that this issue is not only Oracle-related) Regards przemol -- http://przemol.blogspot.com/ ---------------------------------------------------------------------- Fajne i smieszne. Zobacz najlepsze filmiki! >>> http://link.interia.pl/f1bbb _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
