2 messages in com.mysql.lists.mysqlRe: INNODB - Reclaiming ibdata space ...
FromSent OnAttachments
MIchael Johnson06 Feb 2004 15:03 
Heikki Tuuri07 Feb 2004 02:41 
Subject:Re: INNODB - Reclaiming ibdata space and various ibdata questions
From:Heikki Tuuri (Heik@innodb.com)
Date:02/07/2004 02:41:43 AM
List:com.mysql.lists.mysql

Michael,

----- Original Message ----- From: "MIchael Johnson" <webm@yahoo.com> Newsgroups: mailing.database.myodbc Sent: Saturday, February 07, 2004 1:03 AM Subject: INNODB - Reclaiming ibdata space and various ibdata questions

--0-1416817391-1076108604=:94234 Content-Type: text/plain; charset=us-ascii

Good Afternoon and thank you in advance for any help that you may be able to provide.

QUESTION 1 : How do you reclaiming ibdata space?

We have 3 databases that together use several ibdata files (ie each

database does not have its own ibdata file) . We would like to drop 2 databases and reclaim the ibdata space that the 2 databases took up. What is the best way to do this?

QUESTION 2 : Can you have multiple MySQL Instances that contain one

database and a seperate ibdata spaces? Is this the best way to create seperate ibdata files for each database? What would you recommend?

please see http://www.innodb.com/ibman.php#Multiple.tablespaces That solves the disk allocation problems.

QUESTION 3: How can you defrag a database instead of a table?

There is no such command. You have to write a script for that.

We have found that you can defrag a table: "From MySQL Manual: The way to

do the defragmenting is to perform a 'null' alter table operation ALTER TABLE tablename TYPE=InnoDB." We would like to do this for the complete database.

Thanks again for any help.

Respectfully,

Mike

Best regards,

Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables

Order MySQL technical support from https://order.mysql.com/