Date: Fri, 30 Apr 2010 15:39:40 -0600 From: "Jason J. W. Williams" <jasonjwwilliams@gmail.com> To: Pierre Massat <depaulou@efrei.fr> Cc: "freebsd-current@freebsd.org" <freebsd-current@freebsd.org> Subject: Re: ZFS Stability & MySQL (Comments Requested) Message-ID: <x2v3b949f091004301439k89b74175n35a6ddf16b1accf9@mail.gmail.com> In-Reply-To: <w2l4c3c61161004301321i392eb88x37777bba859ff39c@mail.gmail.com> References: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com> <p2i4c3c61161004300104iff071a88w2723795ac94cbf76@mail.gmail.com> <80219502-EDAD-4745-A89B-813601D1C15E@gmail.com> <w2l4c3c61161004301321i392eb88x37777bba859ff39c@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Pierre, By chance did you attempt to write a test file to the ZFS filesystem holding the database and logs? Just curious if ZFS was hung since a MySQL restart corrected it. Thank you for your help. -J On Fri, Apr 30, 2010 at 2:21 PM, Pierre Massat <depaulou@efrei.fr> wrote: > On Fri, Apr 30, 2010 at 3:14 PM, Jason J. W. Williams > <jasonjwwilliams@gmail.com> wrote: >> What was the iowait when the update hangs occurred? Also, what was the box's >> uptime approx when it happened? Have you surpassed that amount of uptime >> since? Were you able to DTrace MySQL to see what func was hanging? > > The iowait was 0.0% when the hangs occurred and the uptime of the box > was something around 120 days and it's currently 166 days (I only > stopped MySQL daemon which was around 60 days of uptime and now 46 > days). > > Unfortunately, I wasn't able to dtrace MySQL. > > -- > Pierre Massat >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?x2v3b949f091004301439k89b74175n35a6ddf16b1accf9>