I have a question about how InnoDB deals with fragmentation within
it's data files. Let me describe my usage scenario to you:
1.) Records are inserted into a InnoDB table. We'll call this table
A. It contains several different kinds of columns including
VARCHARs.
2.) Records are then processed
Hi, ( hopefully a MySQL developer sees this at some point! )
I am giving InnoDB a good workout before rolling it out onto
production systems, and found a bug in the way the tablespace gets fragmented
when doing basic add/drop of indexes. Below my sig is a series of SQL
commands I used to
]
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 table operation:
ALTER TABLE innodbtable TYPE=INNODB;
does the defragmentation with just one build of the table. And I think
[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 table operation:
ALTER TABLE innodbtable TYPE=INNODB;
does the defragmentation with just
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.
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 think it
also
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 PROTECTED]
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
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.
4.0 went
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?
no. We were talking about
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
, 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 innodb
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 and fragmentation
From: Per Andreas Buer
Date: Fri, 22 Aug 2003 09:39:58 +0200
Hi,
We
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 it back
up to speed?
The simplest method is
ALTER
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
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
16 matches
Mail list logo