Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 58

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 26th February 2002, 19:51
makiju's Avatar
makiju makiju is offline
Senior Member
Join Date: Oct 2001
Location: Finland
Posts: 120
makiju is on a distinguished road
Baan: IVc4, LN6.1 - DB: Oracle, Informix - OS: all
Striping by using HP/UX MirrorDisk

Hi all!
How good is HP/UX MirrorDisk striping?
Has anybody measured it in real world? Maybe compared to some hardware striping...and to JBOD's and so on...
I'm just thinking of increasing Baan/Oracle performance.
Maybe $BSE/tmp and Oracle areas.
Reply With Quote
Old 1st March 2002, 09:48
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Hi Jukka,

Striping is not really the right term in connection with LVM mirroring.

Striping is normally done on block level (lets say 2k or something). Mirroring with LVM is done on extent level (most of the time 4 MB). They can not be combined!

What can be done is the so called "distributed allocation" with Mirroring. Here the LVM will just allocate the extents dirtributed over the physical disks.

Yo could call it striping with a stripe size of 4 MB. This obviously is not nearly as good as striping with a much smaller stripesize.

I can not give you concreate measurements. But we use for all our installations distributed allocation with mirroring for the database files! I would not place the redo- or archive logs in the same stripeset as the database files or use the mechanism at all.
Also I would not expect Baan istself or $BSE/tmp to gain much from distributed allocation.

Even without measurements, I have a very good feeling about using distributed allocation. Some HP folks even say, that a FC10 with distributed allocation is as fast or even faster than the raid products (VA7100/VA7400) of HP and might even be able to compete with an XP!

Try it!

Reply With Quote
Sponsored Links
Old 9th March 2002, 20:42
KlayVessel KlayVessel is offline
Join Date: Aug 2001
Location: Atlanta, Georgia
Posts: 30
KlayVessel is on a distinguished road
Baan: 3b2, 4(b-c4), 5c - DB: Oracle 7, Oracle 8, MS-SQL, Informix - OS: HP-UX, AIX, Tru64, Sun, NT, Linux
Uh, Mirror/UX does strip smaller sizes that PE (4MB). That is you can choose strips of 4, 8, 16, 32, or 64K blocks.

I have not done any performance tests though. It would be faster than not stripping and putting the same contents on the volumes.
Kevin Brock, OCP, MCSE / Senior Technical Consultant
Fullscope (formerly RedKlay, formerly QCI)
(Web & Baan Consultants)
Reply With Quote
Old 25th March 2003, 16:16
makiju's Avatar
makiju makiju is offline
Senior Member
Join Date: Oct 2001
Location: Finland
Posts: 120
makiju is on a distinguished road
Baan: IVc4, LN6.1 - DB: Oracle, Informix - OS: all
stripe and mirror with Mirrordisk

Still not clear for me. Can I stripe and mirror with extent size smaller than 1M?
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Striping blank spaces in print expressions pjohns Tools Development 24 20th November 2003 15:39
Password changing in clustered HP/UX makiju Operating Systems & Databases 3 24th October 2002 17:15

All times are GMT +2. The time now is 22:54.

©2001-2018 - -