You are running out of file descriptors. You need to reconfigure your
kernel. If you are running Linux 2.2.x, it's very easy. Just do something
like this:
$ echo 8192 > /proc/sys/fs/file-max
$ echo 32768 > /proc/sys/fs/inode-max
If you are using an earlier Linux, i.e. 2.0.x. Then you will have to
rebuild your kernel with higher number. Edit linux/fs.h and change the
appropriate values.
You need to find out how many fd you need. The above numbers are what I
use, but you may need higher (or lower). Make sure you increase the max
inodes appropriately, recommended number is 4 times max filedescriptors.
Tin Le
----
Net Images - Premier Web Presence Provider http://www.netimages.com/~tin
Internet Security and Firewall Consulting
Tin Le - tin@stripped
On Tue, 1 Feb 2000, Daniel R Sullivan wrote:
> Date: Tue, 1 Feb 2000 17:25:39 -0800
> From: Daniel R Sullivan <dan@stripped>
> To: mysql@stripped
> Subject: Problems with MySQL "timing out" and not accepting connections
>
> Up until Monday I was running 3.22.23, and we kept having mysql stop
> responding to PHP/Apache/Perl requests, and sometimes console requests. PHP
> requests would return this error:
> Warning: MySQL Connection Failed: Lost connection to MySQL server during
> query in /www/html/post.php3 on line 18
> Unable to connect to database.
>
> After upgrading to 3.22.30 the problem has gotten somewhat worse, but we
> have about 3k more transactions per day (and growing by about 1k/day
> everyday) since running 3.22.23.
>
> If you give it some time it will sometimes recover. From the command line
> we'll sometimes
> get an "Unable to write to '/tmp/SQL10bfa_0.ISD' (Errcode: 24)" message.
>
> The system is RH Linux 5.2.
> I can post my my.cnf if that would help.
> There are very few large queries run on the DB (less than 20 a day), but
> this seems to keep happening all the time.
>
> Thanks for your help,
>
> Dan
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread26218@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-tin=netimages.com@stripped>
>
