On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote: > The way to defragment InnoDB tables, or tables in any database, is from time > to time to dump and reimport them. That can give a significant performance > boost. >
That is actually not entirely true. For MyISAM tables, one simply needs to run "OPTIMIZE TABLE table_name" from time to time. I think the end result is the same, but it's atomic. Does OPTIMIZE TABLE work for InnoDB? Steve --------------------------------------------------------------------- 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