Unix Technical Forum

RAID

This is a discussion on RAID within the Oracle Database forums, part of the Database Server Software category; --> Hi All, I have got RAID10 disks and my system is IO bound. I thought that RAID would take ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-24-2008, 01:33 PM
vissuyk@yahoo.com
 
Posts: n/a
Default RAID

Hi All,

I have got RAID10 disks and my system is IO bound. I thought that RAID
would take away all striping problems, but that is not necessarily the
case, why am I having IO issues despite the RAID hw? WIll ASM help

Thanks for any advice.

Vissu

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-24-2008, 01:33 PM
Randy Harris
 
Posts: n/a
Default Re: RAID


<vissuyk@yahoo.com> wrote in message
news:1116557933.338509.122080@g43g2000cwa.googlegr oups.com...
> Hi All,
>
> I have got RAID10 disks and my system is IO bound. I thought that RAID
> would take away all striping problems, but that is not necessarily the
> case, why am I having IO issues despite the RAID hw? WIll ASM help
>
> Thanks for any advice.
>
> Vissu


RAID10 includes striping. It's not going to "take away all striping
problems".

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-24-2008, 01:33 PM
Dusan Bolek
 
Posts: n/a
Default Re: RAID

Maybe you simply have bigger load than is your disk IO capacity. You
can add more disks or use quicker ones. That's the only answer that I
can give to such generic question.

--
Dusan Bolek

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-24-2008, 01:33 PM
Frank van Bortel
 
Posts: n/a
Default Re: RAID

vissuyk@yahoo.com wrote:
> Hi All,
>
> I have got RAID10 disks and my system is IO bound. I thought that RAID
> would take away all striping problems, but that is not necessarily the
> case, why am I having IO issues despite the RAID hw? WIll ASM help
>
> Thanks for any advice.
>
> Vissu
>

It's all about spindles. More spindles = more throughput.
More spindles + more controllers = even better throughput.


What RAID10 (not RAID01?) - what controller(s), how many disks?

--
Regards,
Frank van Bortel
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-24-2008, 01:34 PM
Frank van Bortel
 
Posts: n/a
Default Re: RAID

vissuyk@yahoo.com wrote:
> Hi All,
>
> I have got RAID10 disks and my system is IO bound. I thought that RAID
> would take away all striping problems, but that is not necessarily the
> case, why am I having IO issues despite the RAID hw? WIll ASM help
>
> Thanks for any advice.
>
> Vissu
>

It's all about spindles. More spindles = more throughput.
More spindles + more controllers = even better throughput.


What RAID10 (not RAID01?) - what controller(s), how many disks?

--
Regards,
Frank van Bortel
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 02-24-2008, 01:34 PM
Chuck
 
Posts: n/a
Default Re: RAID

vissuyk@yahoo.com wrote:
> Hi All,
>
> I have got RAID10 disks and my system is IO bound. I thought that RAID
> would take away all striping problems, but that is not necessarily the
> case, why am I having IO issues despite the RAID hw? WIll ASM help
>
> Thanks for any advice.
>
> Vissu
>


Without knowing your actual RAID configuration it's hard to determine
the problem. Here are some questions to consider though.

How many disks in the stripe set? The more disks, the less chance of
head contention.

Have you reached the capacity of your controller?

Is this a SAN configuration? If so, what other applications (possibly on
other unrelated servers) are sharing the physical disks. Do *NOT*
believe what SAN vendors say about their caches eliminating contention.
I have personally seen situations where physical disk contention with
another has caused a database's average i/o time to go from milliseconds
to more than 2 seconds!

--
To reply by email remove "_nospam"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 02-24-2008, 01:34 PM
Chuck
 
Posts: n/a
Default Re: RAID

vissuyk@yahoo.com wrote:
> Hi All,
>
> I have got RAID10 disks and my system is IO bound. I thought that RAID
> would take away all striping problems, but that is not necessarily the
> case, why am I having IO issues despite the RAID hw? WIll ASM help
>
> Thanks for any advice.
>
> Vissu
>


Without knowing your actual RAID configuration it's hard to determine
the problem. Here are some questions to consider though.

How many disks in the stripe set? The more disks, the less chance of
head contention.

Have you reached the capacity of your controller?

Is this a SAN configuration? If so, what other applications (possibly on
other unrelated servers) are sharing the physical disks. Do *NOT*
believe what SAN vendors say about their caches eliminating contention.
I have personally seen situations where physical disk contention with
another has caused a database's average i/o time to go from milliseconds
to more than 2 seconds!

--
To reply by email remove "_nospam"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 02-24-2008, 01:34 PM
HansF
 
Posts: n/a
Default Re: RAID

Define 'IO bound'? Can you trace it to controller, channel or disk? What
is exact config and OS? What tools are you using to determine problem?
Do you have a RAID venfdor or are you doing this on the fly?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 02-24-2008, 01:34 PM
Joe Yong
 
Posts: n/a
Default Re: RAID

RAID 1+0 includes stripping. Did you mean take away stripping with parity
(aka RAID 5 and the likes) problems?

What exactly do you mean by IO issues? Are you suffering flow slow reads or
writes? What is the percentage of read operations vs write? Do you have
physically separate spindles for the database and logs?

As you can see, there are still quite a few things to deal with besides
picking a "better" RAID configuration. If you can provide more details, we
may be able to offer some thoughts on how to identify and address the issues
you're facing.


joe.


<vissuyk@yahoo.com> wrote in message
news:1116557933.338509.122080@g43g2000cwa.googlegr oups.com...
> Hi All,
>
> I have got RAID10 disks and my system is IO bound. I thought that RAID
> would take away all striping problems, but that is not necessarily the
> case, why am I having IO issues despite the RAID hw? WIll ASM help
>
> Thanks for any advice.
>
> Vissu
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 02-24-2008, 01:34 PM
HansF
 
Posts: n/a
Default Re: RAID

Define 'IO bound'? Can you trace it to controller, channel or disk? What
is exact config and OS? What tools are you using to determine problem?
Do you have a RAID venfdor or are you doing this on the fly?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:46 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com