Hi! >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?
Sorry, no. ALTER TABLE can be used to rebuild the table, but essentially it is equivalent to a dump and reimport. >Steve Regards, Heikki -- Order commercial MySQL/InnoDB support at https://order.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