We recently moved a Mysql database from NFS (Netapp) to a local disk array (J4200 with SAS disks). Shortly after moving production, the system effectively hung. CPU was at 100%, and one disk drive was at 100%.
I had tried to follow the tuning recommendations for Mysql mostly: * recordsize set to 16K * primarycache=metadata * zfs_prefetch_disable=1 The theory of primarycache=metadata is that Mysql will do a better job of caching internally than ZFS does. However continuous read of a disk suggested to me that perhaps Mysql was reading something repeatedly. Thus (after restarting everything) I put primarycache back to the default. I haven't seen the problem again. But there's no way to know whether I actually fixed it or whether it was just a fluke. At this point load on the storage is low enough that further tuning doesn't seem worth it. We average less than 1 MB / sec read and write. -- This message posted from opensolaris.org _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
