mysql cluster: checking and repairing tables
We have a mysql cluster. How can we checking and repairing tables ? Thanks ! David Marois DBA <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
Re: Repairing Tables
Use a backup powersupply and shutdown software to gracefully shutdown after a power fail. Yaw Ofori-Adjei wrote: > I have used MySQL for about 2 years nowand I love it. > My only problem is that I am in africa were power > fluctuations are rampant. I usally get table handelr > error 127 after every power outage. S'times simple > repair just doesn't work and the entire database must > be restore. It there a way around this error occuring > after every outage?. Otherwise MySQL is topmost. > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.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 -- Gerald L. Clark [EMAIL PROTECTED] - 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
Re: Repairing Tables
Hello. Have a look at the transaction safe table types (InnoDB, BDB, ...). I did not try them myself, but from what I read on the list, there is a good chance that they will return to a consistent state themselves. Bye, Philemon. PS: Of course, the better solution would be a back-up power supply. ;) On Fri, Jun 22, 2001 at 01:35:55AM -0700, [EMAIL PROTECTED] wrote: > I have used MySQL for about 2 years nowand I love it. > My only problem is that I am in africa were power > fluctuations are rampant. I usally get table handelr > error 127 after every power outage. S'times simple > repair just doesn't work and the entire database must > be restore. It there a way around this error occuring > after every outage?. Otherwise MySQL is topmost. - 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
Re: Repairing Tables
> It there a way around this error occuring > after every outage?. Eeek! Are you running myisamchk -r? - obviously, there isn't really much of a way to avoid having to repair tables after a hard OS crash. I would highly recommend trying to get ahold of something like an APC battery supply which you can monitor on the serial port - then you can safely shut down mysql and shut down the server before you run out of battery power. This of course assumes you can get a hold of a good quality UPS there at a reasonable price. --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:408-970-8840 http://www.reflectivity.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
Repairing Tables
I have used MySQL for about 2 years nowand I love it. My only problem is that I am in africa were power fluctuations are rampant. I usally get table handelr error 127 after every power outage. S'times simple repair just doesn't work and the entire database must be restore. It there a way around this error occuring after every outage?. Otherwise MySQL is topmost. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.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