Hello Heikki, Wednesday, November 21, 2001, 8:34:13 PM, you wrote:
I see some more users are interested in optimize table to work. Why don't you just map OPTIMIZE TABLE to ALTER TABLE for INNODB tables so user may not care about table type, there currently one should check the table type and use OPTIMIZE table or alter table depending on its type. HT> 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? HT> Sorry, no. ALTER TABLE can be used to rebuild the table, but essentially it HT> is equivalent to a dump and reimport. >>Steve HT> Regards, HT> Heikki HT> -- HT> Order commercial MySQL/InnoDB support at https://order.mysql.com/ HT> --------------------------------------------------------------------- HT> Before posting, please check: HT> http://www.mysql.com/manual.php (the manual) HT> http://lists.mysql.com/ (the list archive) HT> To request this thread, e-mail <[EMAIL PROTECTED]> HT> To unsubscribe, e-mail <[EMAIL PROTECTED]> HT> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Peter mailto:[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
