InnoDB File Fragmentation

2008-06-20 Thread Aaron Blew
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

InnoDB tablespace fragmentation bug in MySQL 4.0.20

2004-07-01 Thread Josh Chamas
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

Re: innodb and fragmentation

2003-09-22 Thread Per Andreas Buer
] 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

Re: innodb and fragmentation

2003-09-20 Thread Jon Hancock
[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

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 just fine.

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 think it also

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 PROTECTED]

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

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. 4.0 went

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? no. We were talking about

innodb and fragmentation

2003-08-22 Thread Per Andreas Buer
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

Re: innodb and fragmentation

2003-08-22 Thread Heikki Tuuri
, 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

Re: innodb and fragmentation

2003-08-22 Thread Jeff Mathis
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

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 it back up to speed? The simplest method is ALTER

InnoDb and fragmentation

2003-07-07 Thread mos
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

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