470,648 Members | 1,587 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,648 developers. It's quick & easy.

disk usage increases after dropping a large index?

I have a linux server which is hosting several very large (~20GB)
databases. In order to save some disk space I dropped an index on one
of the larger (InnoDB) tables because it is no longer needed. It took
about 30 minutes for MySQL to drop the index, during which time I saw
the free disk space decrease. I didn't think anything of it while the
drop operation was running because I figured it was some kind of temp
file being used by the drop (even though the temp directory for mysql
is supposed to be on another partition). To my surprise, after the
index was dropped, not only did I not have more free space as I
expected, but in fact I had about 2 GB less than I did before I
dropped the index. Huh?

So now I'm down 1 index and 2 GB of space. How does dropping a db
object actually increases the amount of disk used by mysql? Is there
anyway I can reclaim this space? MySQL version is 4.0.15
Jul 19 '05 #1
0 1821

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by cover | last post: by
6 posts views Thread by Matthew Nuzum | last post: by
7 posts views Thread by matvdl | last post: by
1 post views Thread by Nils Rennebarth | last post: by
7 posts views Thread by Ross Mallett | last post: by
1 post views Thread by mrstephengross | last post: by
1 post views Thread by sowmya.rangineni | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.