I know this is slightly off-topic but it's related to changing the
number of file descriptors on FreeBSD:
---------------------------------------------------------------------
FreeBSD
by Torsten Sturm
How do I check my maximum filedescriptors?
Do sysctl -a and look for the value of kern.maxfilesperproc.
How do I increase them?
sysctl -w kern.maxfiles=XXXX
sysctl -w kern.maxfilesperproc=XXXX
Warning: You probably want maxfiles > maxfilesperproc if you're going
to be pushing the limit.
What is the upper limit?
I don't think there is a formal upper limit inside the kernel. All the
data structures are dynamically allocated. In practice there might be
unintended metaphenomena (kernel spending too much time searching
tables, for example).
----------------------------------------------------------------------
--
The site is here: http://merlin.bmk.hu/Squid/FAQ-11.html
> Running mysql 3.22.32-log on Apache virtual server (FreeBSD)
>
> I can restart my mysql daemon with ./bin/safe_mysqld - but it
> only runs for a few hours before dying. Following hints from
> both the manual and the list, I've tried several things...
>
> I've deleted my mysql database and manually re-installed all
> the tables (instead of using the mysql_install_db script which
> wanted me to do a make compile)
>
> I've looked at the error log, and see nothing that shows why
> it is dying ( though when it starts it does have two messages -
> could they be related?)
>
> Warning: setrlimit couldn't increase number of open files to
> more than 164
> Warning: Changed limits: max_connections: 30 table_cache: 62
>
> I've had the logging on but see no queries that should be the
> problem.
>
> Nothing in the cron file
>
> Any suggestions?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
