Re: innodb and fragmentation

[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, stable in 4.0.12.

3.23 went beta in 3.23.20, gamma in 3.23.28, and stable in 3.23.31.

3.22: 3.22.4 / 3.22.14 / 3.22.17

So, it varies.

It'll happen faster if people try the alphas and pound hard on them. :-)


jeff

Per Andreas Buer wrote:
 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 just fine. Thanks.

 --
 > Per Andreas Buer


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]