List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 27 2002 3:03am
Subject:RE: Optimize InnoDB table...
View as plain text  
At 11:56 +0900 12/27/02, Chung Ha-nyung wrote:
>  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.

Uh, well, what I wrote below shows how to do that. :-)

>Or dump &
>load
>  data.

Do that with two commands:

mysqldump --opt db_name tbl_name > dump.sql
mysql db_name < dump.sql

>
>--
>  Chung Ha-nyung <alita@[neowiz.com|kldp.org]>
>  Sayclub <http://www.sayclub.com>
>  NeoWiz <http://www.neowiz.com>
>
>
>>  -----Original Message-----
>>  From: Paul DuBois [mailto:paul@stripped]
>>  Sent: Friday, December 27, 2002 11:50 AM
>>  To: ¡§ «¦„Á; mysql@stripped
>>  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.

Thread
Optimize InnoDB table...Chung Ha-nyung26 Dec
  • Re: Optimize InnoDB table...Paul DuBois27 Dec
RE: Optimize InnoDB table...Chung Ha-nyung27 Dec
  • RE: Optimize InnoDB table...Paul DuBois27 Dec