On Sunday, Oct 19, 2003, at 05:23 US/Pacific, peter gervai wrote:
If something writes lots of data to the disk (as
'bo' indicates) it can
make others' disk access to stall (uninterruptable wait for disk
resources).
What filesystem do you use?
ext3, which of course means extra journaling overhead.
Is the 12MB/s indicated in 'bo' the speed
limit of your disks, or can
they do
higher average speed? (For example mine does max 20MB/s, and it means
~15MB/s
"average maximum".)
I'd be surprised at much faster than that, particularly when doing
semirandom reads at the same time, probably. Here are the drive models,
I haven't been able to turn up very useful specs from googling yet:
Vendor: IBM Model: DDYS-T36950N Rev: S96H
Vendor: IBM Model: IC35L036UWDY10-0 Rev: S23C
The second drive holds only the innodb data store and backup dump files.
Oh, and Tim: I've hardlinked the slow query log into /usr/local/mysql,
which should be accessible. It's grown a bit over time and sits around
230+megs, so you may wish to cut pieces off with tail. :)
-- brion vibber (brion @
pobox.com)