From owner-freebsd-current@FreeBSD.ORG Fri Apr 30 20:22:22 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 14FBE106564A for ; Fri, 30 Apr 2010 20:22:22 +0000 (UTC) (envelope-from p.massat@gmail.com) Received: from mail-yw0-f183.google.com (mail-yw0-f183.google.com [209.85.211.183]) by mx1.freebsd.org (Postfix) with ESMTP id B8ABD8FC14 for ; Fri, 30 Apr 2010 20:22:21 +0000 (UTC) Received: by ywh13 with SMTP id 13so274234ywh.8 for ; Fri, 30 Apr 2010 13:22:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:cc:content-type; bh=T5MOWrtkqTYJkKNzGLgijyrivw43iVbvDg2aEl3xL6Q=; b=sTgqE36GIiSTCM1MUmRJsFLAm4u2MINqLlNvuOJB04rpoMAkQM+yqqZB1PIia8shDV a2Jp/QoG6B70SDGi9hpalI9cLm0WnWp4eNtWpI/8qu/ZBneSbB8+mSu1BUIRz8q2Sw9s bCpIc+HqZtHFHj6mqn7LB1iDhYa7vfI3dCnKQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; b=gaEQh+zvwBvKQETYm5kI9UFWtHL4T8SQv8RHGzZNpsr7JYOf7WCVh4krcY3uz1FWgG tSjoWPBI4YhciVP6qoKb1YdwuowwkWmHrr7bSKVV1Uwcpb+nCmExcKP6KQIDuiW8aSN5 OLIiHJRRyqJ6+jYw21ySKFj+2Vfi87FAI0fKc= Received: by 10.91.168.7 with SMTP id v7mr694657ago.87.1272658935210; Fri, 30 Apr 2010 13:22:15 -0700 (PDT) MIME-Version: 1.0 Sender: p.massat@gmail.com Received: by 10.100.165.19 with HTTP; Fri, 30 Apr 2010 13:21:53 -0700 (PDT) In-Reply-To: <80219502-EDAD-4745-A89B-813601D1C15E@gmail.com> References: <80219502-EDAD-4745-A89B-813601D1C15E@gmail.com> From: Pierre Massat Date: Fri, 30 Apr 2010 22:21:53 +0200 X-Google-Sender-Auth: 93cbf7636f6f70e8 Message-ID: To: "Jason J. W. Williams" Content-Type: text/plain; charset=UTF-8 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 20:22:22 -0000 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