topic Re: large database Tuned Parameter set in Operating System - HP-UX

large database Tuned Parameter set

Derek Whigham_2 — Wed, 07 Jan 2004 11:21:47 GMT

I have been asked to add this a D320 Server but cannot find any info on it. Any idea's what this contains anyone.

Re: large database Tuned Parameter set

Robert-Jan Goossens — Wed, 07 Jan 2004 11:28:02 GMT

Hi,

There are some templates in sam kernel configuration to create a kernel for databases. Do you think you can get some more information ?

Regards,
Robert-Jan

Re: large database Tuned Parameter set

Derek Whigham_2 — Wed, 07 Jan 2004 11:36:20 GMT

Having looked at sam I have otions but none of them refer to database config's

This machine will be running an C-ISAM Database.

Re: large database Tuned Parameter set

Todd McDaniel_1 — Wed, 07 Jan 2004 11:40:24 GMT

Hope this helps you.

Here is my kmtune output on a development server where I have a rather large 1.2TB DB with a few copies running...

These are fairly normal parms, imho, for a N-4000-55 with 32GB of memory...

Parameter Current Dyn Planned
==========================================
maxdsiz 0x50000000 - 0X50000000
maxdsiz_64bit 0x40000000 - 0X40000000
maxfiles 500 - 500
maxfiles_lim 1024 Y 1024
maxqueuetime - - 0
maxssiz 0x800000 - 0X800000
maxssiz_64bit 0x800000 - 0X800000
maxswapchunks 5000 - 5000
maxtsiz 0x4000000 Y 0X4000000
maxtsiz_64bit 0x40000000 Y 0X40000000
maxuprc 4000 Y 4000
maxusers 2000 - 2000
maxvgs 255 - 255

sema 1 - 1
semaem 16384 - 16384
semmap 1026 - (SEMMNI+2)
semmni 1024 - 1024
semmns 8000 - 8000
semmnu 1024 - 1024
semmsl 2048 Y 2048
semmsl_override - - 2048
semume 64 - 64
semvmx 32767 - 32767

nfile 29529 - (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+
NSTRTEL))

Re: large database Tuned Parameter set

A. Clay Stephenson — Wed, 07 Jan 2004 11:46:01 GMT

Under SAM->Kernel Configuration -> Configurable Parameters -> Actions -> Apply Tuned Paramter Set there may be a Database selection. It was dropped at 11.11 and you really don't want it nohow. You know far better than others what your machine/application requires. The database tuned parameter sets were infamous for setting timeslice to 1 (rather than 10) and that would absolutely cripple a box.

Re: large database Tuned Parameter set

Steven E. Protter — Wed, 07 Jan 2004 11:50:14 GMT

Your best bet is to look at kmtune output from large database systems.

Our systems are not huge, but we tune for growth. Here is some sample output. It is not the bible, its something to think about.

I would warn you that A D320 is not very fast and can't really handle massive databases. I have one in my basement(because nobody else wanted it when we obsoleted it). It can effectively run Oracle but due to limits in memory capacity can't effectively run really huge databases.

SEP

Re: large database Tuned Parameter set

Derek Whigham_2 — Wed, 07 Jan 2004 11:54:30 GMT

Thanks for you help. The machine is running a medium sized C-ISAM database though I may try running it on a spare B1000 workstation I have to improve performace.