From owner-freebsd-hackers Wed Jan 16 14:30:19 2002 Delivered-To: freebsd-hackers@freebsd.org Received: from salmon.maths.tcd.ie (salmon.maths.tcd.ie [134.226.81.11]) by hub.freebsd.org (Postfix) with SMTP id B1FC437B420 for ; Wed, 16 Jan 2002 14:29:40 -0800 (PST) Received: from walton.maths.tcd.ie by salmon.maths.tcd.ie with SMTP id ; 16 Jan 2002 22:29:39 +0000 (GMT) Date: Wed, 16 Jan 2002 22:29:39 +0000 From: David Malone To: Josef Grosch Cc: hackers@freebsd.org Subject: Re: [nicole@unixgirl.com: What is biord?] Message-ID: <20020116222939.GA81401@walton.maths.tcd.ie> References: <20020116141825.A45998@mooseriver.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20020116141825.A45998@mooseriver.com> User-Agent: Mutt/1.3.25i Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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. David. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message