* 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, "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 [EMAIL PROTECTED] with "unsubscribe freebsd-hackers" in the body of the message