What I'd like to do is not to alter table type but to optimize table. Somewhere I read that to optimize the structure of innodb type table, I should alter table type two times: to MyISAM and back to InnoDB. Or dump & load data.
-- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 27, 2002 11:50 AM > To: Á¤ Çϳç; [EMAIL PROTECTED] > Subject: Re: Optimize InnoDB table... > > > At 15:13 +0900 12/26/02, Chung Ha-nyung wrote: > > I've heard that I should periodically alter innodb table > to MyISAM and > > back to InnoDB to optimize table structure. > > I guess only dropping index and recreating it is enough, > but should I > > change table type? > > Dropping an index doesn't change a table's type. You can change the > type like this: > > ALTER TABLE t TYPE = MyISAM; > ALTER TABLE t TYPE = InnoDB; > > > > >query. > > > >-- > > Chung Ha-nyung <alita@[neowiz.com|kldp.org]> > > Sayclub <http://www.sayclub.com> > > NeoWiz <http://www.neowiz.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