[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 Cr
Hi, everyone,
I created two databases DB_A and DB_B whose tables were all in
InnoDB. DB_A has data of approximately 500 G, DB_B has data of about
200G. Later I dropped the entire DB_B because it served only purpose of
testing. I noticed that the size of the table files ibdata1 and ibdata2
di
