List:General Discussion« Previous MessageNext Message »
From:Ozette Brown Date:March 22 2002 7:09pm
Subject:Re: FreeBSD+MySQL
View as plain text  
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 <mysql-thread103918@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-kota=saraksh.alkar.net@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>     Best regards.
> _______________________________________
>         Andrey Kotrekhov kota@stripped
>         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

Thread
FreeBSD+MySQLOzette Brown22 Mar
  • Re: FreeBSD+MySQLAndrey Kotrekhov22 Mar
    • Re: FreeBSD+MySQLOzette Brown22 Mar
      • Re: FreeBSD+MySQLDan Nelson22 Mar
    • Re: FreeBSD+MySQLOzette Brown22 Mar
      • Re: FreeBSD+MySQLDan Nelson22 Mar
        • Re: FreeBSD+MySQLAndrey Kotrekhov25 Mar