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
