Re: [LUG] MySQL on Ext3

[Bill Wilson <bill@xxxxxxxx>]

from bill@xxxxxxxx

IDE drives are fast but can't carry the load of SCSI disks. An analogy is
cars a porche is fast util you stick 10 ton in the back Then a ten ton truck
is quicker. 
Use IDE for up to 4 users and SCSI above. As an example we have customers
using older style SCSI drives running at 20 Mb / sec 12 of them in a RAID
10 which support large data base apps running up to 200 users.

John Daragon wrote:
> On Tuesday 17 December 2002 23:11, Pete Hatton wrote:
>
> Snip of JFS / Database interaction stats
>
> > What would be interesting to see how this compares on a proper server
> > setup, with lots of memory, fast SCSI hard discs etc - anyone got a nice
> > big setup?
> >     
>
>
> I'd be surprised if this would change much.  With 9MB of data, even with free 
> text indexing I'd be surprised if the whole database didn't fit in memory. 
> Modern IDE drives are pretty much as fast as SCSI for most operations (where 
> SCSI really wins through is really that disks on the same string can seek in 
> parallel because of the concept of SCSI disconnect.) (OK - that's not exactly 
> true - some of my SCSI disks rotate at 15000 rpm, so *big* bulk copies may be 
> substantially faster, but then my newest IDE drived have 8MB caches, too.)
>
> So - I think you're seeing a universal truth - journalling twice is not 
> efficient.
>
> jd
>     
    
    
    


***** YLEM DISCLAIMER  *****

To obtain a copy of Ylem's email disclaimer ring 01398 323146

intY has scanned this email for all known viruses (www.inty.com)