On Monday 30 June 2008 11:14:10 James C. McPherson wrote: > Christiaan Willemsen wrote: > ... > > > And that is exactly where ZFS comes in, at least as far as I > > read. > > > > The question is: how can we maximize IO by using the best > > possible combination of hardware and ZFS RAID? > > ... > > > For what I read, mirroring and striping should get me better > > performance than raidz of RAID5. But I guess you might give me > > some pointer on how to distribute the disk. My biggest question > > is what I should leave to the HW raid, and what to ZFS? > > Hi Christiaan, > If you haven't found it already, I highly recommend going > through the information at these three urls: > > > http://www.solarisinternals.com/wiki/index.php/ZFS_Configuration_Gu >ide > http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_G >uide > http://www.solarisinternals.com/wiki/index.php/ZFS_Evil_Tuning_Guid >e > > > I'll defer to Richard Elling and Roch Bourbonnais for specific > suggestions based on your email - as far as I'm concerned they're > the experts when it comes to ZFS tuning and database performance. > > > James C. McPherson > --
I want to save you some time and sufference: I had to add set zfs:zfs_nocacheflush = 1 to /etc/system and reboot to cure the horrible slowness I experienced with all of Myisam engines on ZFS, especially Innodb. I had never seen a DB going so slow until that moment _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss