----- Original Message -----
From: "MIchael Johnson" <webmikester@stripped>
Sent: Saturday, February 07, 2004 1:03 AM
Subject: INNODB - Reclaiming ibdata space and various ibdata questions
> Content-Type: text/plain; charset=us-ascii
> Good Afternoon and thank you in advance for any help that you may be able
> 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
> Thanks again for any help.
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
Order MySQL technical support from https://order.mysql.com/