In my opinion, the discussion is moot. Unless you're running MySQL in a read-only environment, you should never restart the daemon automatically, because an improper shutdown is likely to yield table corruption, and if the tables are corrupted, attempting to write additional data can cause even further corruption.
If the daemon is improperly shut down, you should manually check the tables before restarting. --Michael > -----Original Message----- > From: Brian Reichert [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 20, 2003 1:12 PM > To: [EMAIL PROTECTED] > Subject: Will a SIGTERM shutdown while using LinuxThreads? > > > On another mailing list, there is a discussion about whether > or not it is adequate/proper to manage the MySQL server > process via a watchdog script (namely, DJB's daemontools). > > The point behind this watchdog script is to launch a service > (such as mysqld) in the foreground, and notice if that > process exits. An auxilary tool will send this managed > process a SIGTERM, to request shutdown. > > It has been working for me under FreeBSD, and the MySQL docs > imply this should work for other OSes, but someone just > pointed out to me this info: > <http://www.mysql.com/doc/en/Linux.html> "When using LinuxThreads you will see a minimum of three processes running. These are in fact threads. There will be one thread for the LinuxThreads manager, one thread to handle connections, and one thread to handle alarms and signals." I myself don't use Linux, much less LinuxThreads. Can anyone advise how the theree process/threads should handle a SIGTERM in such a watchdogged environment? -- Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
