subject:"Optimize InnoDB table..."

RE: Optimize InnoDB table...

2002-12-26 Thread Paul DuBois

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 Inn

RE: Optimize InnoDB table...

2002-12-26 Thread Chung Ha-nyung

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,

Re: Optimize InnoDB table...

2002-12-26 Thread Paul DuBois

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'

Optimize InnoDB table...

2002-12-25 Thread Chung Ha-nyung

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? query. -- Chung Ha-nyung Sayclub NeoWiz