RE: DISK configuration - help please.

From: LoughMiller, Gregory <Gregory_LoughMiller_at_bscc.bls.com>
Date: Mon, 21 Aug 2000 08:26:40 -0400
Message-Id: <10596.115080@fatcity.com>

Can you try a couple of other benchmarks for the three disk configurations that you mention??

insert a series of records(say-4 million).
perform an additional benchmark where you have alternate "full table scan reads" and "inserts".

Lets see what the results are from those two benchmarks.. They may prove to be interesting... Granted there are a lot of other variables.....

Greg

-----Original Message-----
From: Rivaldi Bahar [mailto:rivaldi_bahar_at_hotmail.com] Sent: Friday, August 18, 2000 3:27 PM
To: Multiple recipients of list ORACLE-L Subject: RE: DISK configuration - help please.

I have done benchmarking for full table scan (select count(*) from tablename

4.7 millions records) for the same table and same storage parameter in different configurations : 1. For Raid5 (5 disk + 1 parity) : 14 seconds. 2. For Striped 3 disks : 33 seconds. 3. For Plain disks (2 disks concatenated, unfortunately with different file system type) : 87 seconds.

So, why dont you use Raid5....?

Rivaldi

>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Thursday, August 17, 2000 11:14 AM
>
>
> > Get rid of RAID 5.
> >
> > Lyall
> >
> > At 06:46 AM 8/17/00 -0800, you wrote:
> >
> > >I am in the process of building two DB servers - one live and the other
> > >standby. We are not overly concerned with disk capacity - but rather
>with
> > >speed of access.
> > >
> > >Our current configuration is
> > >
> > >primary has 10 disks in RAID 0+1
> > >standby has 6 disks in RAID 5
> > >
> > >This is to give us 5 physical devices for production - I think a
>holdover
>of
> > >OFA guidelines.
> > >
> > >What I am looking for is a bit of advice on the best optin for current
> > >configurations. I can add disks to this later. I am also using
>Veritas
>VM
> > >and FS and so can relayout my RAID 5 to RAID 0+1 pretty easily as well.
> > >Adding disks to the system is also a breaze.
> > >
> > >All of these disks are in one FS mounted to /u01 .. .for easy
>management
>on
> > >our site we elected one mount point and one very expandable FS.
> > >
> > >I am considering breaking my configuration and going with 8 disks in
>0+1
>for
> > >both systems - or going with 10 and 6 but both in 0+1 - I don't think
>that
> > >RAID 5 is a good idea ever - even for a standby system, but there is
>some
> > >pressure to have 5 physical devices and RAID 5 with 6 gives us that
>too...
> > >
> > >
> > >Anybody out there willing to throw two cents my way?
> > >
> > >
> > >thanks!
> > >
> > >adam
> > >--
> > >Author: Adam Turner
> > > INET: ATurner_at_concretemedia.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > --
> > Author: Lyall Barbour
> > INET: lbarbour_at_stanford.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Author: Steve McClure
> INET: steve_at_pactr.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Author: Richard Ji
> INET: richard_at_letsplay.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

-- 
Author: Rivaldi Bahar
  INET: rivaldi_bahar_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

Received on Mon Aug 21 2000 - 07:26:40 CDT