On Mon, Nov 18, 2002 at 10:14:19PM -0700, Mark Stringham wrote: > Howdy - > > I have heard that periodically optimizing tables can be helpful in the > overall maintenance of the table space in the db. Is this correct and how > often should it be done?
Depends how frequently the data in the table changes (delete rows, update, etc.) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 429,420,192 queries (345/sec. avg) --------------------------------------------------------------------- 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
