db performance

Robert Fitzpatrick lists at webtent.net
Thu Jan 17 14:07:21 PST 2008


On Thu, 2008-01-17 at 22:49 +0100, Wojciech Puchar wrote:
> >> is used)? what is more stupid? whould we vote?
> >
> > That was my whole point of showing you the low usage. I take that as a
> > yes, RAID 1+0 would provide a dramatic difference in speed, thanks!
> 
> the only adventage of RAID-5 is less "wasted" space than RAID-1. one and 
> the only adventage. write performance is terrible on small writes - 
> exactly what happens on database usage.
> 
> with today sizes of disks more "wasted" space doesn't make much a problem, 
> as i don't think your database have hundreds of gigabytes.
> 
> did you look how much disks (no matter what RAID or just devices) are 
> actually used?!
> 
> use systat

Using 'systat -iostat' it shows mostly idle with 25-70 MB/s on the aacd0
array. Most of time above 50. Thanks for the help!

-- 
Robert



More information about the freebsd-questions mailing list