Slightly OT: Web server q's - SCSI vs. IDE

Roger McCalman roger at runcircle.co.uk
Tue Oct 30 18:57:45 GMT 2001


On Tue, Oct 30, 2001 at 01:37:44PM -0000, Mark Hughes wrote:
> >From what I've heard in the past, the bottleneck with databases (we use
> MySQL) is almost always the hard drive, so to that end, in terms of
> performance, how much difference will having SCSI drives make over IDE?
> 
> Also, would having shedloads of RAM (looking at 1GB initially, because of
> the stupid prices at the moment) make any difference to the IDE vs SCSI
> equation? The entire of our database currently is only 100MB odd, is there
> any way to make MySQL cache *all* that data into RAM?

If MySql does not cache the data OS should (via the disk block
cache). On large tables if the index is not in memory your performance
will suffer badly even with RAID'd SCSI disks.

If all the data is in memory then you will be bottled necked by the CPU
or the threading.

Cheers, Roger





More information about the Ukfreebsd mailing list