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

Reply via email to