From owner-freebsd-hackers  Wed Jan 16 15:15:57 2002
Delivered-To: freebsd-hackers@freebsd.org
Received: from elvis.mu.org (elvis.mu.org [192.203.228.196])
	by hub.freebsd.org (Postfix) with ESMTP id 1677A37B416
	for <hackers@freebsd.org>; Wed, 16 Jan 2002 15:15:50 -0800 (PST)
Received: by elvis.mu.org (Postfix, from userid 1192)
	id D8ADF10DE05; Wed, 16 Jan 2002 15:15:49 -0800 (PST)
Date: Wed, 16 Jan 2002 15:15:49 -0800
From: Alfred Perlstein <bright@mu.org>
To: David Malone <dwmalone@walton.maths.tcd.ie>
Cc: Josef Grosch <jgrosch@mooseriver.com>, hackers@freebsd.org
Subject: Re: [nicole@unixgirl.com: What is biord?]
Message-ID: <20020116151549.O26067@elvis.mu.org>
References: <20020116141825.A45998@mooseriver.com> <20020116222939.GA81401@walton.maths.tcd.ie>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <20020116222939.GA81401@walton.maths.tcd.ie>; from dwmalone@walton.maths.tcd.ie on Wed, Jan 16, 2002 at 10:29:39PM +0000
Sender: owner-freebsd-hackers@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-hackers.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-hackers>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-hackers>
X-Loop: FreeBSD.ORG

* David Malone <dwmalone@walton.maths.tcd.ie> [020116 14:30] wrote:
> On Wed, Jan 16, 2002 at 02:18:25PM -0800, Josef Grosch wrote:
> >  I have a mysql database that seems slow and when looking at it in top it
> > always seems to be in a state of biord
> >  What the heck is biord I can't find this anywere
> 
> 22:21:gonzo 3% fgrep biord /usr/src/sys/kern/*
> /usr/src/sys/kern/vfs_bio.c:            tsleep(&bp->b_xflags, PRIBIO, "biord", 0);
> /usr/src/sys/kern/vfs_bio.c:                    tsleep(bp, PRIBIO, "biord", 0);
> 
> If you have a look at the code, in vfs_bio.c around these lines,
> you'll see it is to do with waiting for buffers to be read or
> written. Basically it means that the database is spending alot
> of its time waiting for the disk to catch up.

If you compile mysql using the linuxthreads port instead of freebsd
native threads you _might_ see a performance improvement.

-Alfred

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-hackers" in the body of the message