You said you are running Solaris 10 FCS but zfs was not released until Solaris 10 6/06 which is Solaris 10U2.
On 12/7/06, Jason J. W. Williams <[EMAIL PROTECTED]> wrote:
Hi Dale, Are you using MyISAM or InnoDB? Also, what's your zpool configuration? Best Regards, Jason On 12/7/06, Dale Ghent <[EMAIL PROTECTED]> wrote: > > Hey all, I run a netra X1 as the mysql db server for my small > personal web site. This X1 has two drives in it with SVM-mirrored UFS > slices for / and /var, a swap slice, and slice 7 is zfs. There is one > zfs mirror pool called "local" on which there are a few file systems, > one of which is for mysql. slice 7 used to be ufs, and I had no > performance problems when that was the case. There is 1152MB of RAM > on this box, half of which is in use. Solaris 10 FCS + all the latest > patches as of today. > > So anyway, after moving mysql to live on zfs (with compression turned > on for the volume in question), I noticed that web pages on my site > took a bit of time, sometimes up to 20 seconds to load. I'd jump on > to my X1, and notice that according to top, kernel was hogging > 80-100% of the 500Mhz CPU, and mysqld was the top process in CPU use. > The load average would shoot from a normal 0.something up to 6 or > even 8. Command-line response was stop and go. > > Then I'd notice my page would finally load, and that corresponded > with load and kernel CPU usage decreasing back to normal levels. > > I am able to reliably replicate this, and I ran lockstat while this > was going on, the output of which is here: > > http://elektronkind.org/osol/lockstat-zfs-0.txt > > Part of me is kind of sure that this is 6421427 as there appears to > be long and copious trips through ata_wait() as that bug illustrates, > but I just want to be sure of it (and when is that bug seeing a > solaris 10 patch, btw?) > > TIA, > /dale > _______________________________________________ > 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
_______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
