MySQL quitting, restarts only after hard reboot

2003-02-19 Thread Bill Leonard
This one is still biting us.. any suggestions on where to troubleshoot 
would be appreciated.

Mac OS X Server, 10.2.1 - MySQL 3.23.51

Heavy usage, but no more than 50 open connections at a time

Occasionally, MySQL just quits serving databases. The first indication 
is a forum or something comes up with a could not connect to database 
message.

Logging in to MySQL via the command line works, but a show databases 
command shows an empty set.

The error log in /var/mysql doesn't show anything helpful, only the 
last time it was started.

Re-starting mysqld from the command line doesn't work.

Only rebooting the machine seems to work, but clearly, there must be 
something I don't understand.

What could be going on that it exhibits this behavior? Any ideas?

Thanks much...

Bill


-
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



MySQL quitting, restarts only after hard reboot

2003-02-16 Thread Bill Leonard
Strange problem, maybe someone can help!

Mac OS X Server, 10.2.1 - MySQL 3.23.51

Occasionally, MySQL just quits serving databases. The first indication 
is a forum or something comes up with a could not connect to database 
message.

Logging in to MySQL via the command line works, but a show databases 
command shows an empty set.

The error log in /var/mysql doesn't show anything helpful, only the 
last time it was started.

Re-starting mysqld from the command line doesn't work.

Only rebooting the machine seems to work, but clearly, there must be 
something I don't understand.

So what could be going on that it shows this behavior? Any ideas?

Thanks for any ideas.

Bill



--
Bill Leonard [EMAIL PROTECTED]
www.machinemen.com  407.464.0147

XrackHosting.com - Mac OS X hosting on Apple's Xserve!
http://www.xrackhosting.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