Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dropping a column isn't reducing the disk size #8673

Closed
clanstyles opened this issue Dec 12, 2018 · 3 comments
Closed

Dropping a column isn't reducing the disk size #8673

clanstyles opened this issue Dec 12, 2018 · 3 comments
Labels
type/question The issue belongs to a question.

Comments

@clanstyles
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    If possible, provide a recipe for reproducing the error.
    Write a bunch of data, drop the column.

  2. What did you expect to see?
    The on disk size to go down

  3. What did you see instead?
    Stays the same, actually goes up a little bit.

  4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

'Release Version: v2.0.7\nGit Commit Hash: 29ec059cb3b7d14b6f52c2f219f94a89570162bc\nGit Branch: release-2.0\nUTC Build Time: 2018-09-07 12:36:02\nGoVersion: go version go1.11 linux/amd64\nTiKV Min Version: 2.0.0-rc.4.1'
@lysu lysu added the type/question The issue belongs to a question. label Dec 13, 2018
@zimulala
Copy link
Contributor

zimulala commented Dec 13, 2018

@clanstyles
After we do an operation of drop column, we only drop a column schema and don't drop the data now.
We will drop the column data in the future.

@clanstyles
Copy link
Author

What's supposed to happen if we run out of space? How can we clean this up?

@zimulala
Copy link
Contributor

@clanstyles
The problem of insufficient space due to not reclaiming the space after the "drop column" has not yet been resolved. We will deal with this issue.

@Defined2014 Defined2014 closed this as not planned Won't fix, can't repro, duplicate, stale Aug 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/question The issue belongs to a question.
Projects
None yet
Development

No branches or pull requests

5 participants