Hello again, I've now been on the list long enough to determine it's not an inactive list ... So, I'm hoping that means that someone (perhaps one of the MySQL team I've seen active on the list today) may be able to address this problem, as it is quite a serious one.
Is there a reason that it's not even covered in the documentation? I'd love to hear something back ... While I've been a MySQL user for many years, I'm feeling the urge to spend the time I'm spending waiting to hear something looking for a more stable and reliable database to run on Mac OS X Server. -Clay PS -- I'm running MySQL 3.23.49, but have experienced this problem in other MySQL versions on Mac OS X Server. ___________________________ Clay Loveless Webmaster, Crawlspace http://www.crawlspace.com/ > From: Clay Loveless <[EMAIL PROTECTED]> > Date: Fri, 19 Apr 2002 17:26:25 -0700 > To: <[EMAIL PROTECTED]> > Subject: Intermittent 1049 error > > Hello, > > I'm running a relatively busy MySQL server on Mac OS X Server 10.1.4. MySQL runs on > a dedicated dual G4 500, with 1.5 GB of RAM and an 18GB 15k rpm Ultra160 > Cheetah drive. No other services besides MySQL run on this machine. > > Roughly 3-5 times per day, my MySQL server suddenly "forgets" most or all of > its databases, and begins claiming that they don't exist with an error 1049. > > I've searched the mailing list (found 3 messages with 1049 in the archives, > none of which described this problem), the online docs (error 1049 isn't > even mentioned), and Google (which found 150+ pages who are apparently > having this same problem, but found no answers) ... > > I can't believe I'm the only one having this problem, but since there's no > mention of it anywhere that I can find, I am beginning to wonder. > > Can anyone shed some light on this issue, and hopefully, offer a remedy? > > Thanks in advance. > > -Clay > > ( > > Further info -- the server hosts only about 15-20 databases, the total size > of which is less than 1.5 GB. Well under 2MM records total. > > mysqladmin status as of this writing: > Uptime: 205602 Threads: 145 Questions: 4293056 Slow queries: 0 Opens: > 207 Flush tables: 1 Open tables: 202 Queries per second avg: 20.880 > > ) > > ___________________________ > Clay Loveless > Webmaster, Crawlspace > http://www.crawlspace.com/ > > > > > --------------------------------------------------------------------- > 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
