From owner-freebsd-current@FreeBSD.ORG Fri Apr 30 21:39:45 2010 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id EAB62106566C for ; Fri, 30 Apr 2010 21:39:45 +0000 (UTC) (envelope-from jasonjwwilliams@gmail.com) Received: from mail-px0-f182.google.com (mail-px0-f182.google.com [209.85.212.182]) by mx1.freebsd.org (Postfix) with ESMTP id BDF6A8FC0A for ; Fri, 30 Apr 2010 21:39:45 +0000 (UTC) Received: by pxi17 with SMTP id 17so424331pxi.13 for ; Fri, 30 Apr 2010 14:39:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=gbpjNpjXQWJ3SQTMTFNGJ2FaPCvS34HVmENgKhzfdVs=; b=GN5NNFjwmwwEDAj4H71Ni8Qrh4KHVPj0dzHTS1pNXFZyOtMmOwyyHzs00+fS+AIEbA 3OU2oEYf6z52GJGrWFZP6HjglnraI9Ko840/D0sPhCRQnFe1XTOL17vawnP9/exA9YGk keMdaNpWpfBsTO2CqRHeE2ytfat2alh0RsXaI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=w6Vk7Eq/fsVEbQWC2aecCRBVYXf/Ww0a21PuPAs7ocOztQZJuR9DJdlFAEtf94cCyw ORkTMSxjukJuclksV216NrimcQxRvpbIu8C+oHu7Wy19Cl1VULYa6rfXp2DKOMvMCk77 uthIrCPT9xMU14wK/UOmMDNlM8stphiP1Twbc= MIME-Version: 1.0 Received: by 10.141.107.15 with SMTP id j15mr1345197rvm.288.1272663580552; Fri, 30 Apr 2010 14:39:40 -0700 (PDT) Received: by 10.141.27.20 with HTTP; Fri, 30 Apr 2010 14:39:40 -0700 (PDT) In-Reply-To: References: <80219502-EDAD-4745-A89B-813601D1C15E@gmail.com> Date: Fri, 30 Apr 2010 15:39:40 -0600 Message-ID: From: "Jason J. W. Williams" To: Pierre Massat Content-Type: text/plain; charset=ISO-8859-1 Cc: "freebsd-current@freebsd.org" Subject: Re: ZFS Stability & MySQL (Comments Requested) X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 Apr 2010 21:39:46 -0000 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 wrote: > On Fri, Apr 30, 2010 at 3:14 PM, Jason J. W. Williams > 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 >