Hello, Some basic points about these problems: 1) have you another application/mysqld listening on the same tcp port? 2) have you tried different versions (switching between 3.23 and 4.x series, for example) 3) try compiling from the source with a bit different configuration parameters 4) do your connections drop if you're connecting from the localhost? How about from other hosts? How about connecting with other clients?
Just don't give up. I've never seen a MySQL-related problem that nobody has been able to solve. I don't believe this isn't about anything big. And probably there are lots of more people active on this list next week, somebody of them might be able to solve your problem. :-) Regards, Iikka ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** On Sun, 18 Aug 2002, Gelu Gogancea wrote: > My dear friend, > If you put the problem in this way .....maybe it's a good ideea to go to the > church and make some rosary for solving your problem. > > Bye > > ----- Original Message ----- > From: "Chris Knipe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, August 18, 2002 9:06 PM > Subject: Re: Lost connections on Freebsd > > > > Fair enough, > > > > But then why is MySQL the *only* thing I am having problems with? MySQL's > > not the only application running on the box, it's not the only application > > opening / closing tcp sockets, its not the only thing opening / closing > file > > sockets.... > > > > *shrugs*... Maybe I should just rm -rf / and reinstall..... > > > > ----- Original Message ----- > > From: "Gelu Gogancea" <[EMAIL PROTECTED]> > > To: "Chris Knipe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Sunday, August 18, 2002 8:01 PM > > Subject: Re: Lost connections on Freebsd > > > > > > > For sure "Bad file descriptor" error occur because your kernel it's not > > > able to create handler for the new open file(don't forget...socket it's > > also > > > a file ) which must be open. > > > > > > _____________________________________________________ > > > G.NET SOFTWARE COMPANY > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > ----- Original Message ----- > > > From: "Chris Knipe" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Sunday, August 18, 2002 8:14 PM > > > Subject: Re: Lost connections on Freebsd > > > > > > > > > > > > > > > ...or you have too many open files in the system.You reach the max. > > > number > > > > > of files which can be opened by the OS.Try to increase file-max from > > > > > /proc/sys/fs. > > > > > > > > > > > > > Highly doubtful. It's a brand new server installation, exactly the > same > > > as > > > > all my others, and it's not doing half as much as the others are.... > > > > > > > > The box runs mysql, apache, and exim... With less than 50 processes > > > running > > > > at any given time... > > > > > > > > It's FreeBSD as well btw, /proc/fs/ doesn't exist :P > > > > > > > > -SNIP- > > > > DESCRIPTION > > > > The fstat utility identifies open files. A file is considered > open > > > by > > > > a > > > > process if it was explicitly opened, is the working directory, > root > > > > directory, active executable text, or kernel trace file for that > > > > process. > > > > If no options are specified, fstat reports on all open files in > the > > > > sys- > > > > tem. > > > > -SNIP- > > > > > > > > 749 open files reported... Far less than the maximum. > > > > > > > > -- > > > > me > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > 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 > > > > > > > --------------------------------------------------------------------- > 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
