>>>>> "Chris" == Chris Unger <cunger@stripped> writes:
Chris> Below is a snippet from the /var/log/messages on a machine. I am hoping
Chris> this is a problem with mysql 3.22.20a and that the simple upgrade to 3.23.x
Chris> will solve the problem...
Chris> Any help would be greatly appreciated. If you need more info, please let
Chris> me know!
Chris> Mysqladmin reports this:
Chris> mysqladmin Ver 7.8 Distrib 3.22.20a, for unknown-freebsd2.2.7 on i386
Chris> /var/log/messages:
Chris> [charm] ~/EUsers/testing> tail /var/log/messages
Chris> Jun 21 16:24:43 charm syslogd: /dev/ttyp0: Too many open files in system
Chris> Jun 21 16:24:43 charm last message repeated 3 times
Chris> Jun 21 16:24:43 charm /kernel: file: table is full
Chris> Jun 21 16:24:43 charm syslogd: /dev/ttyp0: Too many open files in system
Chris> Jun 21 16:24:43 charm last message repeated 3 times
Chris> Jun 21 16:24:43 charm /kernel: file: table is full
Chris> Jun 21 16:24:43 charm syslogd: /dev/ttyp0: Too many open files in system
Chris> Jun 21 16:24:43 charm last message repeated 3 times
Chris> Jun 21 16:24:43 charm /kernel: file: table is full
Chris> Jun 21 16:24:43 charm last message repeated 28 times
Hi!
The above means that your FreeBSD kernel doesn't have enough file
descriptors!
You need to recomile your kernel with more file descriptors!
You may also be able to do as root:
sysctl -w kern.maxfiles=100000 <-- can be any number you like
sysctl -w kern.maxfilesperproc=100000
ulimit -n 100000
Regards,
Monty
