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
e. And I think it
> also preserves FOREIGN KEY constraints.
>
> Please test it!
>
> Best regards,
>
> Heikki
> Innobase Oy
> http://www.innodb.com
> InnoDB - transactions, foreign keys, and a hot backup tool for MySQL
>
> ..
> Subject: innodb
ansactions, foreign keys, and a hot backup tool for MySQL
..
Subject: innodb and fragmentation
From: Per Andreas Buer
Date: Fri, 22 Aug 2003 09:39:58 +0200
Hi,
We have an InnoDB database which is get quite fragmented. We defragment
it about once a month, converting the table from
Hi,
We have an InnoDB database which is get quite fragmented. We defragment
it about once a month, converting the table from innodb to myisam and
back. After a defragmentation our database performance is more or less
doubled. IO-strain is reduced with 50%.
Would it be possible to have "alter tabl
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 me
Heikki,
Do InnoDb tables suffer from internal table fragmentation. (Is there any
way to measure it?) I only mention this because of a problem I have with
another database system (not MySQL). Some of its tables are hopelessly
fragmented (800,000 file fragments for one table alone! Did I set a ne
14 matches
Mail list logo
