Re: DBWR performance
Date: Sat, 19 May 2012 09:16:23 -0700 (PDT)
Message-ID: <727f35d4-5ba7-41a0-bc03-144adaabc71c_at_googlegroups.com>
Guys, you are missing elephant in the room here - cost. How much does that IBM box + storage for it?
This is pc box that costs less than 3K and doing 1GBytes/sec sustained, which is faster than those 2FC cards.
iostat -k 5
...
avg-cpu: %user %nice %system %iowait %steal %idle
0.13 0.00 9.13 15.07 0.00 75.68
Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 4.20 12.80 10.40 64 52
sdb 1305.00 334080.00 0.00 1670400 0
sdc 1331.20 340787.20 0.00 1703936 0
sdd 1273.80 326092.80 0.00 1630464 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.63 0.00 10.42 20.05 0.00 68.90
Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 504.20 6884.80 0.00 34424 0
sdb 1378.60 352921.60 0.00 1764608 0
sdc 1325.20 339251.20 0.00 1696256 0
sdd 1338.20 342579.20 0.00 1712896 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.28 0.00 9.30 15.31 0.00 75.11
Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 1.60 6.40 0.00 32 0
sdb 1343.00 343859.20 0.00 1719296 0
sdc 1285.20 329011.20 0.00 1645056 0
sdd 1304.00 333824.00 0.00 1669120 0
And this could be improved by getting:
- second controller
- more hdd
- switching from hdd to sdd
You may not like bus architecture and IRQs but that stuff works and cpu cycles are cheap - there is not much use for those extra cores anyway, they are pretty idle.
11 years ago I was looking at red hat 7 box and HP UX box side by side and was asking myself - why do we need that old HP 9000 crap? It was worse from hardware, software and cost perspective.
3 years ago I did some CPU benchmark of our SUN box using the java code and int calculations - speed was about the same as our average core 2 desktop.
My buddy is constantly complaining about SUN CPUs failing on a regular basis. The same was my experience with DEC Alphas. When was a last time you have seen Intel CPU failed?
Sorry, but PCs are way to go and this is where hardware have improved for the last 30 years dramatically.
Andrew
On Saturday, May 19, 2012 6:50:49 AM UTC-5, Noons wrote:
> Mladen Gogala wrote,on my timestamp of 18/05/2012 10:17 PM:
>
> > attempt of addressing this performance shortcoming has failed. However,
> > if you stack up enough of Dell boxes together, you will get the same
> > capacity as with a single iPower box, especially if you use Exadata.
>
> That was the whole motivation to shove RAC down everyone's throats...
>
> > I am not sure that the price will remain low, however. Hardware is now
> > dirt cheap and for a price of a single Oracle license, I can buy 10 very
> > good PC's. Having one powerful iPower machine with 8GB or even 16GB FC/AL
> > interfaces and a decent general purpose SAN for DW is probably much more
> > cost effective than having 4 way RAC, with Exadata. Performance should be
> > comparable, if not better.
>
> I can certainly confirm our 32 core iPower6 is an absolute screamer. Fastest
> box I've ever seen, at that price point. I do 8TB/day in a 3TB DW db - that's
> an average sustained 100MB/s IO rate 24X7, if it was averaged (it isn't). That
> P6 box is running as well a JDE system on AS400/DB2 emulation, and just about
> every other Peoplesoft db and app servers in our place, in multiple vio
> partitions. It hardly ever breaks a sweat!
> In peak periods, I've seen the SAN service the DW lpar at 730MB/s aggregate
> sustained, with hardly any I/O waits. On 2X4Gbps FC cards attached to the DW
> partition, that's just about as fast as one can hope to ever do I/O in such
> hardware. I'm looking forward to the 8Gbps FCs we have on order!
Received on Sat May 19 2012 - 11:16:23 CDT