From owner-freebsd-threads@FreeBSD.ORG Tue Nov 24 15:53:38 2009 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E9511106568D for ; Tue, 24 Nov 2009 15:53:38 +0000 (UTC) (envelope-from asmrookie@gmail.com) Received: from mail-fx0-f218.google.com (mail-fx0-f218.google.com [209.85.220.218]) by mx1.freebsd.org (Postfix) with ESMTP id 7EF5E8FC34 for ; Tue, 24 Nov 2009 15:53:38 +0000 (UTC) Received: by fxm10 with SMTP id 10so4050039fxm.14 for ; Tue, 24 Nov 2009 07:53:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to:cc :content-type; bh=C6Wx9ndPDjSBZJFxlsa101NMS8GjRp5sUpvXYDTJNtI=; b=kTWz1OLehvSnTSd9FZXVlTcW9XaIoERUFKdU7gQJ9ESwslGvv+7YVr7iuV3QAl/bcV 3hfhev396ZJUqDcenp4n80Fk0H6g2qghCefffgZ2x2nVXRI3Oi3xQLF6vX0IGCex56zg RFCZXliKGYk0JThHdB0QoaEDRg0SvOuDVGrAo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; b=AE5fjjw5aTryvzJ5cpOF0UkaCGyxbyrEetlUyGpobWtNVcNlMpRLHwgfuYvQFGH/IP rQpYtBf157irOxECHnzAYqEGIvEje2ixH3bUcfKispdP0jikuoAL6YZpcujmageOHpEG DrXpXd2szRvvwWkYnOHNU8BS0TeYpjC8uETKc= MIME-Version: 1.0 Sender: asmrookie@gmail.com Received: by 10.223.7.91 with SMTP id c27mr1031278fac.14.1259078017489; Tue, 24 Nov 2009 07:53:37 -0800 (PST) In-Reply-To: <200911241550.nAOFo3WM032896@freefall.freebsd.org> References: <200911241550.nAOFo3WM032896@freefall.freebsd.org> Date: Tue, 24 Nov 2009 16:53:36 +0100 X-Google-Sender-Auth: 04db9e2fbd714dc6 Message-ID: <3bbf2fe10911240753i4fe41b74j760cbcd88a096b8d@mail.gmail.com> From: Attilio Rao To: Conor McDermottroe Content-Type: text/plain; charset=UTF-8 Cc: freebsd-threads@freebsd.org Subject: Re: threads/135673: databases/mysql50-server - MySQL query lock-ups on 7.2-RELEASE amd64 X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Nov 2009 15:53:39 -0000 2009/11/24 Conor McDermottroe : > The following reply was made to PR threads/135673; it has been noted by GNATS. > > From: Conor McDermottroe > To: bug-followup@FreeBSD.org, freebsd-bugs@desert.net > Cc: > Subject: Re: threads/135673: databases/mysql50-server - MySQL query > lock-ups on 7.2-RELEASE amd64 > Date: Tue, 24 Nov 2009 15:19:38 +0000 > > Thanks very much for the patch, we were running into it as well. The good > news is that it improves the situation quite a bit. The bad news is that > it does not appear to cure the problem entirely. Under heavy load we see > the same problem re-occurring. > > We'll be bringing up another machine with 8.0 in the coming weeks and I > hope to test it then. > > We're currently avoiding this bug by under-loading the 7.2 machine and > handling more queries on a different 7.0 machine. Is there any > information I can provide which would help diagnose this bug further? My last findings were revealing a sudden zeroing of userland structures where a lock was embedded, leaving some waiters on such locks stuck in the kernel. I think this is a MySQL bug and I feel to suggest you to upgrade to newest MySQL versions. Attilio -- Peace can only be achieved by understanding - A. Einstein