[zfs-discuss] ZFS problem with oracle

2008-04-01 Thread Wiwat Kiatdechawit
I implement ZFS with Oracle but it slower than UFS very much. Do you have
any solution?

 

Can I fix this problem with ZFS direct I/O. If it can, how to set it?

 

Wiwat

 

___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss


Re: [zfs-discuss] ZFS problem with oracle

2008-04-01 Thread Ed Saipetch

Wiwat,

You should make sure that you have read the Best Practices Guide and the 
Evil Tuning Guide for helpful information on optimizing ZFS for Oracle.  
There are some things you can do to tweak ZFS to get better performance 
like using a separate filesystem for logs and separating the ZFS intent 
log (ZIL) from the main pool.


They can be found here:
http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide
http://www.solarisinternals.com/wiki/index.php/ZFS_Evil_Tuning_Guide

Also, what kind of disk subsystem (number of disks, is it an array?, 
etc.) and how do you have your zfs pools configured (raid type, separate 
ZIL, etc.)?


Hope this gives you a start.

-Ed

Wiwat Kiatdechawit wrote:


I implement ZFS with Oracle but it slower than UFS very much. Do you 
have any solution?


 


Can I fix this problem with ZFS direct I/O. If it can, how to set it?

 


Wiwat

 




___
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