Hi, I'm new at the Database Maintenance Role. Can anyone tell me what are the basic things that need to be done to keep my database healthy ?
i.e. I've heard that it's good to regularly rebuild indexes. How frequently should that be done ? And what is the best way to go about it. ----- Original Message ----- From: "Kalok Lo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Egor Egorov" <[EMAIL PROTECTED]> Sent: Thursday, January 24, 2002 11:51 AM Subject: Re: how to repair bdb tables? > I'm having the same need. > It looks like the following is intended for MyISAM tables only: > http://www.mysql.com/doc/U/s/Using_mysqlcheck.html > > Has anyone else had any other luck ? > > > > ----- Original Message ----- > From: "Egor Egorov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 23, 2002 9:41 AM > Subject: how to repair bdb tables? > > > > Hello Christian, > > > > Wednesday, January 23, 2002, 2:03:18 PM, you wrote: > > > > CH> Hello > > > > CH> I just wondered how to repair/check a berkeley db (bdb) table. I > cannot > > CH> use (my)isamchk and neither the check table/repair table commands. > > > > CH> At least without a check facility the transaction support for MySQL is > > CH> not very usable for production servers (innodb seems to be to buggy > yet, > > CH> I saw several entries in the change log in every of the last few > releasees) > > > > and also look at the output of: mysqlcheck --help > > > > > > > > > > > > > > -- > > For technical support contracts, goto https://order.mysql.com/ > > This email is sponsored by Ensita.net http://www.ensita.net/ > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Egor Egorov > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > > <___/ www.mysql.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 > > > --------------------------------------------------------------------- > 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
