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> In-Reply-To: <20020116222939.GA81401@walton.maths.tcd.ie>; from dwmalone@walton.maths.tcd.ie on Wed, Jan 16, 2002 at 10:29:39PM %2B0000 References: <20020116141825.A45998@mooseriver.com> <20020116222939.GA81401@walton.maths.tcd.ie>
next in thread | previous in thread | raw e-mail | index | archive | help
* 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020116151549.O26067>