GAH!!!

seems this solved all my stupid questions.

# safe_mysqld --open-files-limit=256 &

# fstat | grep mysqld | wc -l
      69

Ill stop asking so much and spamming now.

Lars

On Thu, 25 Apr 2002, Lars wrote:

>
> Ok im still having these problems and ive tried a few things.
>
> I compiled the kernel with options nproc=2048
> (i read this on a webpage)
>
> Ive also did this to change things global.
>
> # sysctl -w kern.maxfiles=8192
> # sysctl -w kern.maxvnodes=32768
>
> I started tracking the number of files opened by mysqld with this.
>
> # while sleep 1; do fstat | grep mysqld | wc -l; done
>
> Still got those strange errors when i reach above 63 open files in the
> mysqld, and as a fact the standard max open file descs are according to
> ulimit -a 64 so ive tried to change this for the mysql user.
>
> # ulimit -n 8192
>
> Still got the same problem, then i checked the procs info with
>
> # sysctl  proc.3469.rlimit.descriptors.soft
> proc.3469.rlimit.descriptors.soft = 64
>
> Then i changed it to 2048
>
> # sysctl -w proc.3469.rlimit.descriptors.soft=2048
> proc.3469.rlimit.descriptors.soft: 64 -> 2048
>
> Still got that damn too many open files error :/
>
> Anyway of compiling into the kernel how many i can have? as default?
>
> I could really need your help guys.
>
> lars
>
> Cell: +46 70 328 02 46
> Mail: cryptr@cryptr.net
> Home: http://www.cryptr.net/
>
> - Thirty years after its creation, UNIX still remains a phenomenon -
>
>
>

Cell: +46 70 328 02 46
Mail: cryptr@cryptr.net
Home: http://www.cryptr.net/

- Thirty years after its creation, UNIX still remains a phenomenon -