topic Re: open_files_limit for mysql in Operating System - HP-UX

open_files_limit for mysql

Mihails Nikitins — Thu, 05 May 2005 09:05:03 GMT

Hi,

I have ported Linux MySQL HA solution provided by HP to HP-UX platform.

My kernel has the following parameters:
naxfiles 60 (Soft File Limit Per Process)
maxfiles_lim 1024 (Hard File Limit Per Process )

I see that mysqld can reach maxfiles_lim, but I don't understand where it is allowed.

open-files-limit parameter is not set in my.cnf, no ulimit command can be found in other files.

Many thanks and points in advance for clarification of this default behavior!

BR,
Mihails

Re: open_files_limit for mysql

Steven E. Protter — Thu, 05 May 2005 09:11:33 GMT

Thats too low for any database server.

make maxuprc 200 to 300

Bump the files limits up.

This needs to be handled in the kernel.

kmtune ouput to check it.

SEP

Re: open_files_limit for mysql

Eric Antunes — Thu, 05 May 2005 09:16:31 GMT

I'm not sure if I've understood the question but I think you should increase maxfiles to 1024 and set nfile to (15*NPROC+2048). This last parameter (should be something greater than 5000) may be more usefull since it limits all open files in the server.

Best Regards,

Eric

Re: open_files_limit for mysql

Mihails Nikitins — Fri, 06 May 2005 00:38:10 GMT

Thanks for your replies!
I tried to find out, where mysqld process is allowed to reach maxfiles_lim, if soft limit is small. Is it necessary to allow it explicitly?

Re: open_files_limit for mysql

Ermin Borovac — Fri, 06 May 2005 01:23:21 GMT

Non-superuser process can increase soft limit by using setrlimit(2) (RLIMIT_NOFILE). It can raise the limit up to the value defined by hard limit (maxfiles_lim).

My guess is that if you search MySQL source code, you will find instances where soft limit is increased using setrlimit(2).