Re: MySQL not using optimum disk throughput.

[John David Duncan]

> And no performance diff.  Note that you're benchmarks only show a 20M
> addition overhead.  We're about 60x too slow for these drives so I'm 
> not
> sure what could be going on here :-/



I know of a site that encountered a similar performance issue:
The OS was reading in a lot more data from the disk than the
database really needed.

The culprit turned out to be the stripe size on a 4-disk RAID.
By reducing the stripe size from 768K to 32K, they obtained a
200% increase in mysql throughput.

- JD