I'm having a problem with mysql forgetting the location
of it's datadir. After the server has been running for
some time, it looses track and starts throwing errors
when I attempt to select a database. Killing mysqld
and letting safe_mysqld restart it fixes the problem
for a while, but having to do it 10 times a day is a
bit much.
I've recompiled the server with the datadir set via
./configure instead of the command line of safe_mysqld.
That seems to have reduced but not eliminated the
frequency of the problem. This could also be a side
effect of less traffic on the weekends.
mysqld - 3.23.29
gcc - 2.95.2
OS - MaxOS 10.0, Darwin 1.3.7
Apache - 1.3.19
PHP - 4.0.x?
I'm currently waiting for it to start throwing these
errors again before I can do a mysqladmin variables
and extended-status. These will be submitted via
support.mysql.com
Has anybody else seen this kind of behavior? Any
suggestions on how to debug it?
Thanks,
Rene
--
René Churchill [EMAIL PROTECTED]
Vermont Web Wizard, LLC 802-244-5151
Specializing in Web Programming 802-244-5512 (fax)
http://www.vtwebwizard.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
