Hi Matthew, We had a similar problem that caused us to need to run myisamchk much more than we wanted to. It turned out that MySQL was not being shutdown when Unix was.
Symptom: The MySQL server error log did NOT show normal shutdown messages. Cause 1: The normal method of shutting down MySQL uses kill to send a signal to the process. That was NOT working on SCO Open Server 5. Cause 2: We did not properly understand where to put the Unix shutdown scripts. Solution: Created a correct script: /etc/rc0.d/K95mysql AND changed it to use "mysqladmin ... shutdown" rather than kill. Result: MySQL now shuts down nicely in all cases except server power cuts. Normal shutdown messages on its log. More robust data. Stephen > -----Original Message----- > From: Matthew Bloch [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 3:34 AM > To: [EMAIL PROTECTED] > Cc: Peter Taphouse; Alec O'Donnell > Subject: Frequently corrupt tables > > > Hello all; > > I'm running several MySQL installation (all version 3.23.37 under Linux) > under what I presume are some fairly harsh conditions, and wondered what > circumstances cause tables to be corrupted and need fixing with myisamchk. > This is happening once every few days and it's becoming a pain. I have a > multithreaded process which is constantly opening and closing connections > to the database and trying to increase its concurrency until the load > average reaches something comfortable like 15, and the network connection > is saturated. I've had to throttle it back to stop it opening more than > 32 simultaenous DB connections but otherwise it works fine. Until I start > getting errors from the table handler, that is, and the whole thing grinds > to a halt until I fix the table manually. > > Can anybody shed some light on this? I can't believe I'm putting it under > more load than something like Slashdot would, and they don't (appear to) > have half the troubles I've had. > > cheers, > > -- > Matthew > http://www.soup-kitchen.net/ --------------------------------------------------------------------- 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
