Date: Tue, 24 Nov 2009 16:53:36 +0100 From: Attilio Rao <attilio@freebsd.org> To: Conor McDermottroe <ports@mcdermottroe.com> Cc: freebsd-threads@freebsd.org Subject: Re: threads/135673: databases/mysql50-server - MySQL query lock-ups on 7.2-RELEASE amd64 Message-ID: <3bbf2fe10911240753i4fe41b74j760cbcd88a096b8d@mail.gmail.com> In-Reply-To: <200911241550.nAOFo3WM032896@freefall.freebsd.org> References: <200911241550.nAOFo3WM032896@freefall.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
2009/11/24 Conor McDermottroe <ports@mcdermottroe.com>: > The following reply was made to PR threads/135673; it has been noted by GNATS. > > From: Conor McDermottroe <ports@mcdermottroe.com> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3bbf2fe10911240753i4fe41b74j760cbcd88a096b8d>