Andrey Kotrekhov wrote: > Добрый день. > > I have the same problem. > We increase max number of users in the kernel config and recompile. > The problem is solve at most. > Try to increase max number of open files in kernel. > > > Hi, > > > > I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem > > is weird an unpreditable. I have a database driven website which has > > several hundred visitors per day. After viewing my logs on a daily > > basis, I see a "Unknown database" error appear from time to time. Now, > > I also have a script set in cron which accesses the database every so > > often an I see the same "Unknown database" error from time to time when > > this script is ran. The error is completely spuradic and > > unpredictable. Sometimes I go for days without seeing the problem. Not > > only that, if I notice the problem immediately and check things out, I > > can connect to the database. So within a matter of minutes it goes from > > an Unknown database to a > > database that is alive and accessible. > > > > I've tried upping the "mbufs", checking the "file descriptors", > > "tweaking the mysqld server params", applying "soft-updates", and > > "turning off Apache::DBI", nothing seems to work. I've seen at least 2 > > other mailing list entries where people have the exact same problem. > > The only solution I received was to switch to a Linux OS. > > > > I've also read that there is a threading problem with FreeBSD+MySQL on > > an SMP machine. I'm running a machine with only 1 processor. > > > > Do you have any idea as to what may be causing this problem and if so, > > do you have a suggested solution? > > > > Any help you may be able to give will certainly be appreciated. > > > > Thanks, > > > > Ozette Brown > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > Best regards. > _______________________________________ > Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > тел. +380 562 34-00-44
Andrey, Thank you for the reply. I read somewhere that when checking your maximum file descriptors your "kern.maxfiles should be greater than kern.maxfilesperproc. My settings are: kern.maxfiles = 8232 kern.maxfilesperproc = 8232 So, with that said, my kern.maxfiles should be much higher, no (based on your reply)? When I check my maximum file descriptors, I should see: somenumber / what I set my kern.maxfiles to be ....example: 535/8232 Is this correct? Also, are you running the same version of FreeBSD (4.3-stable) and MySQL (3.23.39)? Thanks, Ozette --------------------------------------------------------------------- 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
