Re: innodb and fragmentation

2003-09-22 Thread Per Andreas Buer
e - > From: "Per Andreas Buer" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, September 19, 2003 6:17 PM > Subject: Re: innodb and fragmentation > > >> Hello Heikki, >> >> "Heikki Tuuri" <[EMAIL PRO

Re: innodb and fragmentation

2003-09-20 Thread Jon Hancock
uot;Per Andreas Buer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 19, 2003 6:17 PM Subject: Re: innodb and fragmentation > Hello Heikki, > > "Heikki Tuuri" <[EMAIL PROTECTED]> writes: > > > I think a 'null' alter ta

Re: innodb and fragmentation

2003-09-19 Thread Jeff Mathis
Paul DuBois wrote: > > At 12:40 PM -0600 9/19/03, Jeff Mathis wrote: > >this looks great. will this work with version 4.04 on solaris? > > > >as a side comment, anyone know when 4.1 will get out of the alpha stage? > >very much looking forward to upgrading, but only when its relatively > >stable.

Re: innodb and fragmentation

2003-09-19 Thread Paul DuBois
At 12:40 PM -0600 9/19/03, Jeff Mathis wrote: this looks great. will this work with version 4.04 on solaris? as a side comment, anyone know when 4.1 will get out of the alpha stage? very much looking forward to upgrading, but only when its relatively stable. 4.0 went beta in 4.0.3, gamma in 4.0.6,

Re: innodb and fragmentation

2003-09-19 Thread Jeff Mathis
this looks great. will this work with version 4.04 on solaris? as a side comment, anyone know when 4.1 will get out of the alpha stage? very much looking forward to upgrading, but only when its relatively stable. jeff Per Andreas Buer wrote: > > Hello Heikki, > > "Heikki Tuuri" <[EMAIL PROTECT

Re: Re: innodb and fragmentation

2003-09-19 Thread Franky Van Liedekerke
Per Andreas Buer <[EMAIL PROTECTED]> wrote: Hello Heikki, > >"Heikki Tuuri" writes: > >> I think a 'null' alter table operation: >> >> ALTER TABLE innodbtable TYPE=INNODB; >> >> does the defragmentation with just one build of the table. And I thi

Re: innodb and fragmentation

2003-09-19 Thread Per Andreas Buer
Hello Heikki, "Heikki Tuuri" <[EMAIL PROTECTED]> writes: > I think a 'null' alter table operation: > > ALTER TABLE innodbtable TYPE=INNODB; > > does the defragmentation with just one build of the table. And I think it > also preserves FOREIGN KEY constraints. > > Please test it! It did the job

Re: innodb and fragmentation

2003-08-23 Thread Heikki Tuuri
Jeff, - Original Message - From: "Jeff Mathis" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, August 23, 2003 12:20 AM Subject: Re: innodb and fragmentation > does shutting down the database server and restarting it have the same > effect

Re: innodb and fragmentation

2003-08-22 Thread Jeff Mathis
does shutting down the database server and restarting it have the same effect? jeff Heikki Tuuri wrote: > > Per, > > I think a 'null' alter table operation: > > ALTER TABLE innodbtable TYPE=INNODB; > > does the defragmentation with just one build of the table. And I think it > also preserves

Re: innodb and fragmentation

2003-08-22 Thread Heikki Tuuri
Per, I think a 'null' alter table operation: ALTER TABLE innodbtable TYPE=INNODB; does the defragmentation with just one build of the table. And I think it also preserves FOREIGN KEY constraints. Please test it! Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, fo

Re: InnoDb and fragmentation

2003-07-13 Thread Heikki Tuuri
Sorry, - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 12:39 AM Subject: Re: InnoDb and fragmentation > Mike, ... > > So how do I "defrag" the InnoDb file space so I can get

Re: InnoDb and fragmentation

2003-07-07 Thread Heikki Tuuri
Mike, - Original Message - From: "mos" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 5:54 PM Subject: InnoDb and fragmentation > Heikki, > Do InnoDb tables suffer from internal table fragmentation. (Is there any > way to measure it?) I only mention t