Looks like you're running out of the file descriptor to handle the
connection etc.
I'm not really a FreeBSD person but here's what I've found on this
site:
http://ircache.nlanr.net/Polygraph/Tips/FreeBSD-3.3/
Try increasing max file descriptors in /sys/conf/param.c
#define MAXFILES (16384)
This *could* the problem try it and see how you go with it.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 10, 2001 9:55 AM
> To: [EMAIL PROTECTED]
> Subject: URGENT - daemon dying frequently
>
>
> 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
>
---------------------------------------------------------------------
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