Re: [RAC 11gR2] stress tool
From: joel garry <joel-garry_at_home.com>
Date: Wed, 7 Aug 2013 09:59:59 -0700 (PDT)
Message-ID: <49c9c813-0058-4dc5-be62-56f2fb4cad14_at_googlegroups.com>
On Monday, August 5, 2013 1:40:15 PM UTC-7, nor..._at_maillard.im wrote:
> Mladen Gogala <gogala.mladen _at_gmail.com> writes:
>
>
>
> > On Mon, 05 Aug 2013 00:06:38 +0200, noreply wrote:
>
> >
>
> >> Hello,
>
> >>
>
> >> I was charged to stress a 3-nodes 11gR2 RAC database last week. I have
>
> >> tried many approaches in order to detect the "breakpoint" but I failed.
>
> >>
>
> >> I never reached this limit and thus, I could not conclude anything about
>
> >> the current setup.
>
> >>
>
> >> This is the first time I try to "benchmark" a 11gR2 RAC database and I
>
> >> must confess, I have no idea how to break it down.
>
> >>
>
> >> What tool could I use to reach the breakpoint ? What method would you
>
> >> use to do so ?
>
> >>
>
> >> The nodes are all like this: HP-UX 11iv3 - 8 cores - 16G RAM. 10Gb
>
> >> interlink (UDP).
>
> >>
>
> >> Thank you very much
>
> >
>
> > Now, that's a simple task: create two tables, in a parent->child
>
> > relationship (foreign key) and update them from all 3 nodes
>
> > simultaneously, doing a mix of inserts, updates and deletes. Make sure
>
> > that all 3 nodes do work on the same blocks. It will break it, no matter
>
> > how powerfull the nodes are.
>
>
>
> Ah exact. This is not really what I need in fact ^^. Maybe my english is
>
> not good to describe it correctly.
>
>
>
> Let my try again.
>
>
>
> What I would like to test is the throughput of the system. I need
>
> to show how powerfull the system is and how many TPS it can support
>
> before it will break.
>
>
>
> I agree this is all dependent on the SQL code being written by the
>
> developers and this can't be taken as a "proof".
>
>
>
> I just need to stress it until it break in a "theorical sense" -i.e
>
> placing the environment as if it was the best conditions it could ever
>
> face - (a little bit like in an Oracle Lab ;)) and report that number
>
> (#user, #tps, ...).
>
>
>
> Hope it is clearer :)
>
>
>
> Thank you
>
> --
>
> XMA
You might want to google Oracle SLOB.
Date: Wed, 7 Aug 2013 09:59:59 -0700 (PDT)
Message-ID: <49c9c813-0058-4dc5-be62-56f2fb4cad14_at_googlegroups.com>
On Monday, August 5, 2013 1:40:15 PM UTC-7, nor..._at_maillard.im wrote:
> Mladen Gogala <gogala.mladen _at_gmail.com> writes:
>
>
>
> > On Mon, 05 Aug 2013 00:06:38 +0200, noreply wrote:
>
> >
>
> >> Hello,
>
> >>
>
> >> I was charged to stress a 3-nodes 11gR2 RAC database last week. I have
>
> >> tried many approaches in order to detect the "breakpoint" but I failed.
>
> >>
>
> >> I never reached this limit and thus, I could not conclude anything about
>
> >> the current setup.
>
> >>
>
> >> This is the first time I try to "benchmark" a 11gR2 RAC database and I
>
> >> must confess, I have no idea how to break it down.
>
> >>
>
> >> What tool could I use to reach the breakpoint ? What method would you
>
> >> use to do so ?
>
> >>
>
> >> The nodes are all like this: HP-UX 11iv3 - 8 cores - 16G RAM. 10Gb
>
> >> interlink (UDP).
>
> >>
>
> >> Thank you very much
>
> >
>
> > Now, that's a simple task: create two tables, in a parent->child
>
> > relationship (foreign key) and update them from all 3 nodes
>
> > simultaneously, doing a mix of inserts, updates and deletes. Make sure
>
> > that all 3 nodes do work on the same blocks. It will break it, no matter
>
> > how powerfull the nodes are.
>
>
>
> Ah exact. This is not really what I need in fact ^^. Maybe my english is
>
> not good to describe it correctly.
>
>
>
> Let my try again.
>
>
>
> What I would like to test is the throughput of the system. I need
>
> to show how powerfull the system is and how many TPS it can support
>
> before it will break.
>
>
>
> I agree this is all dependent on the SQL code being written by the
>
> developers and this can't be taken as a "proof".
>
>
>
> I just need to stress it until it break in a "theorical sense" -i.e
>
> placing the environment as if it was the best conditions it could ever
>
> face - (a little bit like in an Oracle Lab ;)) and report that number
>
> (#user, #tps, ...).
>
>
>
> Hope it is clearer :)
>
>
>
> Thank you
>
> --
>
> XMA
You might want to google Oracle SLOB.
jg
-- _at_home.com is bogus. http://www.computerworlduk.com/news/infrastructure/3462174/ad-standards-group-reports-oracle-authorities-for-ibm-attack/Received on Wed Aug 07 2013 - 18:59:59 CEST