Re: [zfs-discuss] performance problem with Mysql

2010-02-20 Thread Bryan Allen
+-- | On 2010-02-20 08:45:23, Charles Hedrick wrote: | | I hadn't considered stress testing the disks. Obviously that's a good idea. We'll look at doing something in May, when we have the next opportunity to take down th

Re: [zfs-discuss] performance problem with Mysql

2010-02-20 Thread Charles Hedrick
I hadn't considered stress testing the disks. Obviously that's a good idea. We'll look at doing something in May, when we have the next opportunity to take down the database. I doubt that doing testing during production is a good idea... -- This message posted from opensolaris.org _

Re: [zfs-discuss] performance problem with Mysql

2010-02-20 Thread Charles Hedrick
We had been using the same pool for a backup Mysql server for 6 months before using it for the primary server. Neither zpool status -v nor fmdump shows any signs of problems. -- This message posted from opensolaris.org ___ zfs-discuss mailing list zfs-

Re: [zfs-discuss] performance problem with Mysql

2010-02-20 Thread Bryan Allen
+-- | On 2010-02-20 08:12:53, Charles Hedrick wrote: | | 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. CP

[zfs-discuss] performance problem with Mysql

2010-02-20 Thread Charles Hedrick
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