Re: Raid 5 for oracle

From: Brad (xxxxxxx_at_xxx.xxx)
Date: 07/03/04 

Date: Sat, 3 Jul 2004 17:54:38 -0400

"McBofh" <james.N0SPAm.mcpherson@optusnet.com.au> wrote in message
news:40E57871.9010107@optusnet.com.au...
> Bridge wrote:
> > I am creating a raid 5 device for oracle.
> > Could some one tell what the interlace and inode size to use to get
> > better performance?
>
> Firstly, "better performance" compared to what?
>
> Secondly, your DBA should be telling you what is required
> performance-wise from the storage. This includes
>
> read/write mix
> expected proportion of random versus sequential io
> headroom (ie, how much growth allowed)
> whether raw or filesystem (ufs / vxfs, then the myriad
> of options like directio, forcedirectio, qlog etc)
>
>
> If you're using _software_ raid5 I suggest to you that
> you're not using the best option. Hardware raid5 is
> quite fine because you don't have to spend your server's
> cpu cycles recalculating parity all the time.
>
Even with hardware, Raid 5 is not always the best. Using HP HSG-80 raid
controllers, 0+1 has shown us better I/O throughput than Raid 5.

Brad

Relevant Pages

  • Re: Raid 5 for oracle
    ... > I am creating a raid 5 device for oracle. ... > Could some one tell what the interlace and inode size to use to get ...
    (comp.unix.solaris)
  • Re: some simple nfs-benchmarks on 5.4 RC2
    ... RAID 5 depends on fast xor, so a slow processor ... > in a hardware RAID5 box will slow you down a lot. ... This can't be done in hardware, since atabeast only supports raid 0, ...
    (freebsd-performance)
  • Re: some simple nfs-benchmarks on 5.4 RC2
    ... RAID 5 depends on fast xor, so a slow processor ... >>in a hardware RAID5 box will slow you down a lot. ... A lost ounce of gold may be found, a lost moment of time never. ...
    (freebsd-performance)
  • Re: how to check if RAID is implemented?
    ... >I just took over the SQL 2000 server from the former DBA. ... This is more of a Net Admin question, however, as a DBA, you *should* know ... Check to see if there is a Software package installed that manages the RAID ...
    (microsoft.public.sqlserver.server)
  • RE: Optimal File System config for 2.5TB RAID5
    ... I got Perc 4E-DI Embedded Raid Adapter from DELL for my current SCSI ... performance between software RAID and hardware RAID. ... Could you please tell me if this type of hardware RAID controller could ... hardware RAID5 doesn't require much knowledge and ...
    (freebsd-questions)