From owner-freebsd-threads@FreeBSD.ORG Mon Aug 1 11:00:21 2011 Return-Path: Delivered-To: freebsd-threads@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C7A2C106566B for ; Mon, 1 Aug 2011 11:00:21 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 9CEEC8FC13 for ; Mon, 1 Aug 2011 11:00:21 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id p71B0Lim005153 for ; Mon, 1 Aug 2011 11:00:21 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id p71B0LaZ005152; Mon, 1 Aug 2011 11:00:21 GMT (envelope-from gnats) Date: Mon, 1 Aug 2011 11:00:21 GMT Message-Id: <201108011100.p71B0LaZ005152@freefall.freebsd.org> To: freebsd-threads@FreeBSD.org From: Shane Bester Cc: 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 Reply-To: Shane Bester List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 01 Aug 2011 11:00:21 -0000 The following reply was made to PR threads/135673; it has been noted by GNATS. From: Shane Bester 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: Mon, 01 Aug 2011 11:57:37 +0200 Hi! Can anybody who frequently hits this hangup with relatively simple queries against MyISAM tables please let us know if this solves or avoids the issue: Add to [mysqld] section of my.cnf: concurrent_insert=0 or SET GLOBAL concurrent_insert=0;