Alfred Perlstein wrote:
> * David Malone <[EMAIL PROTECTED]> [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, "bior
d", 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
If mysql is blocking on bioread, then it is stalling the entire thread
engine when one hits disk IO. Using the linuxthreads port cant help but
make it work better / more smoothly.. especially if there are multiple
clients.
Cheers,
-Peter
--
Peter Wemm - [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
"All of this is for nothing if we don't go to the stars" - JMS/B5
To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-hackers" in the body of the message
