Ah, thanks for asking that -- I meant to include that in my original description of the scenario, as it's another thing that's really odd about the problem: there is NOTHING in the error logs at the time the problem happens.
I've got a script running that checks the number of "visible" databases once per minute. When the number falls below the number that there should be, the script restarts mysqld. This is the same point -- when the "visible" database count falls below what it should -- that the 1049 errors start getting kicked out of other scripts (message boards, etc.). I'm using a widely distributed binary for Mac OS X built by Marc Liyanage ... Version 3.23.49 with InnoDB support compiled in. I'm experienced with MySQL, but haven't done much with InnoDB, and don't presently have a need. I chose the binary install since Apple frequently runs behind on distributing MySQL releases, and I didn't see the need to re-compile if there was a decent binary available. Is it possible that the inclusion of InnoDB support (that isn't used or configured) could be a contributing factor to the problem? If that notion makes no sense, I won't bother with re-compiling ... But if it's a remote possibility, I can always compile my own version if it could eliminate the trouble. Thanks for the input, Mark -- I appreciate it. -Clay ___________________________ Clay Loveless Webmaster, Crawlspace http://www.crawlspace.com/ > From: "Mark Matthews" <[EMAIL PROTECTED]> > Date: Thu, 25 Apr 2002 16:39:56 -0500 > To: "Clay Loveless" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: Re: how to get support help? > > What does your MySQL error log say when this happens? (it should be in the > same directory with your databases and be your hostname plus a ".err" > extension). This information should shed some light on what's going on under > the hood. > > -Mark > > Original message: > ------------------------------------------------------------ > Subject: Re: how to get support help? > From: Clay Loveless <[EMAIL PROTECTED]> > Date: 2002-04-25 17:50:48 > [Download message RAW] > > Erik, et. al.-- > > Thanks for all the helpful advice. > > I'll make a note that the MySQL mailing list welcomes messages from people > shrieking "HELP!!!" even though they clearly haven't bothered to read the > manual, but offers little to those who've actually tried to resolve a > problem on their own BEFORE wasting everyone else's time and bandwidth. > > This approach is contrary to other lists I'm a part of, so I'm glad you've > helped me get my mind right on how *this* list (clearly an anomaly) works. > > Anyone else offering the "buy a contract" response can save their > keystrokes, I'm now crystal clear on that solution. > > -Clay > > > > --------------------------------------------------------------------- > 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
