search for: where_do_you_cache_oracle

...irtual disk has a ZFS file system. When we try to create a tablespace we get these errors: WARNING: aiowait timed out 1 times WARNING: aiowait timed out 2 times WARNING: aiowait timed out 3 times ... Does disk_asynch_io = false need to be set with ZFS? This page: http://blogs.sun.com/glennf/entry/where_do_you_cache_oracle says "ZFS which doesn''t allow for direct or async IO." but nothing else I''ve found indicates that setting must be set. Thanks This message posted from opensolaris.org

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? This message posted from opensolaris.org