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
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
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.
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,
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
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
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
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
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
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
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
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
12 matches
Mail list logo