[snip] I assume that the space of "InnoDB free: 201787392 kB" was resulted from the dropping of DB_B. Will this chunk be re-used when new data is inserted? [/snip]
InnoDB tablespace will not shrink when data is removed. The space the you have from the dropped database will be reused. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]