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:[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.
---------------------------------------------------------------------
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