Hello, I'm running a relatively busy MySQL server on Mac OS X Server. 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