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)