From owner-freebsd-current@FreeBSD.ORG  Tue Jul 20 10:40:58 2004
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
Delivered-To: freebsd-current@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id E5EA816A4CE
	for <freebsd-current@freebsd.org>;
	Tue, 20 Jul 2004 10:40:58 +0000 (GMT)
Received: from gundel.de.clara.net (gundel.de.clara.net [212.82.225.86])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8089843D2D
	for <freebsd-current@freebsd.org>;
	Tue, 20 Jul 2004 10:40:58 +0000 (GMT)
	(envelope-from jesk@killall.org)
Received: from port-212-202-54-113.dynamic.qsc.de ([212.202.54.113]
	helo=turbofresse)
	by gundel.de.clara.net with smtp (Exim 4.30; FreeBSD)
	id 1BmsCt-000Jkh-Qm
	for freebsd-current@freebsd.org; Tue, 20 Jul 2004 12:50:47 +0200
Message-ID: <027e01c46e46$04224f60$45fea8c0@turbofresse>
From: "jesk" <jesk@killall.org>
To: <freebsd-current@freebsd.org>
References: <20040618143134.4512.qmail@web14101.mail.yahoo.com>
Date: Tue, 20 Jul 2004 12:40:46 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Subject: Re: Possible Threading problem with -CURRENT / MySQL?
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 20 Jul 2004 10:40:59 -0000

i got problems too with mysql under freebsd 5.2.1 and CURRENT.

i got these problems on two machines with different hardware, but both are
single cpu machines.
used scheduler is ULE.

problem description:
under high i/o load the mysqld isnt responding any more.
i tested this with dd if=/dev/urandom of=testfile bs=128k on the hdd an was
not
able to become any ouput from simple select-statements within a long period
of time
(above minutes).
i dont know if this problem occurs from mysql and its threads or if the i/o
subsystem has
any problems to deal fast enough with two intensives read and write
processes and its
priorities.

best regards,
christian