On Fri, Mar 28, 2003 at 11:15:42PM -0500, Bill Leonard wrote: > One of our servers has been acting up recently... There is about 400 > databases on the machine, about 1000 requests per hour. > > Every so often, once every couple days or so, the databases just disappear. > Doing a show databases command yields an empty set. Actually sometimes, it > shows 1 or 2 in there. > > Any ideas as to what could be causing this, or how to troubleshoot it to > narrow it down further? MySQL is not quitting apparently, the databases just > disappear. Shutting down the service and restarting it fixes it.
Any chance you're running FreeBSD? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 53 days, processed 1,833,329,271 queries (394/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]