topic Re: maxfiles_lim > 2048 sensible setting? in Operating System - HP-UX

maxfiles_lim > 2048 sensible setting?

Ralph Grothe — Mon, 17 Sep 2001 18:24:30 GMT

Database procs ran obvoiusly into trouble reaching the boundary of simultaniously open files.
Now I'm tempted not only to increase the soft limit (i.e. maxfiles) to 1024, but also to raise the hard limit (i.e. maxfiles_lim).
Does this make sense to you experienced sysadmins for a database server that also has to serve many HTTP requests?
I have absolutely no idea of plausible values.

Re: maxfiles_lim > 2048 sensible setting?

Christopher McCray_1 — Mon, 17 Sep 2001 18:28:27 GMT

On all of my servers the maxfiles and maxfiles_lim is 2048 or more. You can't go wrong if you set them to 2048.

Good luck
Chris

Re: maxfiles_lim > 2048 sensible setting?

Ralph Grothe — Mon, 17 Sep 2001 18:42:37 GMT

Hi Christopher,

I don't want to run into trouble again.
My settings currently are:

# grep maxfile /stand/system
maxfiles 120
maxfiles_lim 2048

but these were to low.
So I want to set maxfiles_lim beyond 2048

Re: maxfiles_lim > 2048 sensible setting?

Sanjay_6 — Mon, 17 Sep 2001 18:42:55 GMT

Hi Ralph,

If you want you can apply the HP-UX tuned kernel parameter set for OLTP Database server system. This tunes most of the parameters required for oracle ... database purposes. It will set the maxfiles limit to 2048 by default.

To do this, do

sam --> Kernel Configuration --> Configurable kernel Parameters --> Selct Action from the top bar ---> Apply tuned parameter set --> Select OLTP System / Database Server System.

Rebuild Kernel and reboot. Hopefully you may not be required to tune the kernel parameters again until and unless an application specifically demands it.

Hope this helps.

thanks

Re: maxfiles_lim > 2048 sensible setting?

Ralph Grothe — Mon, 17 Sep 2001 18:49:14 GMT

Hi Sanjay,

my set of kernel params derives from this mentioned parameter set.

Re: maxfiles_lim > 2048 sensible setting?

Christopher McCray_1 — Mon, 17 Sep 2001 18:54:59 GMT

Your maxfiles_lim is actually fine; it is your maxfiles is what needs upping. You can set it the same value as you _lim if you want.

BTW - What type of server do you have? It may/may not have something to do with it???

Good luck
Chris

Re: maxfiles_lim > 2048 sensible setting?

Sanjay_6 — Mon, 17 Sep 2001 19:01:44 GMT

Hi Ralph,

Just checked my system kernel parameters.

maxfiles =2048
maxfiles_lim = 2048

though you can increase the parameter to the value you want, but you should not have to.

We have Oracle parallel server and MC / SG running on these systems.

Hope this helps.

thanks

Re: maxfiles_lim > 2048 sensible setting?

Christopher McCray_1 — Mon, 17 Sep 2001 19:05:51 GMT

Also, you can look at this link,

http://us.support.external.hp.com/cki/bin/doc.pl/sid=4e6f0b0803272d4b25/screen=ckiDisplayDocument?docId=200000039545441

Maybe it will help

Re: maxfiles_lim > 2048 sensible setting?

Christopher McCray_1 — Mon, 17 Sep 2001 19:20:49 GMT

I just skimmed this doc, but from what I thought I saw, you need to build the kernel manually if you want these parms > 2048. See below:

http://us-support.external.hp.com/cki/bin/doc.pl/sid=d0b7866b05f648439f/screen=ckiDisplayDocument?docId=200000055459688

Re: maxfiles_lim > 2048 sensible setting?

Satish Y — Tue, 18 Sep 2001 07:39:53 GMT

Hi Ralph,

U should not and I think u cannot increase maxfiles_lim greater than 2048

Actual limits are min=30,max=2048 for both maxfiles and maxfiles_lim(u can see with sysdef cmd). But plausible values for the system not running any SQL server is 60 & 1024 and for the system running SQL server is 1024 & 2048.

Cheers...
Satish.