Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle a little better under very high load. Steve Meyers
> -----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/ > > ICQ 19482073 > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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