ZFS Stability & MySQL (Comments Requested)

[Jason J. W. Williams]

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 at efrei.fr> wrote:
> On Fri, Apr 30, 2010 at 3:14 PM, Jason J. W. Williams
> <jasonjwwilliams at 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
>