MySQL Forums
Forum List  »  Quality Assurance

DB Size Doesn't Decrease After Dropping Tables
Posted by: Dan F
Date: October 06, 2007 03:41PM

Hi,

Our database keeps expanding in size, even though I keep deleting tables, and we're now out of disk space. Might anyone offer a suggestion?

I often do analysis by creating scratch tables. However, after I drop these tables, the DB size doesn't decrease. The existing tables should take 10-15GB in size (e.g., if they were exported as CSV files, they would be 10-15GB). However, the database plus a couple indexes are now 50GB.

For reference, we're using MySQL 5.0; the tables are InnoDB; and I'm using the default installation with only one change in the config file (I set "innodb_locks_unsafe_for_binlog=1" instead of to 0).

Any suggestions would really be appreciated, as we're almost out of disk space.

Thanks so much,

Dan

Options: ReplyQuote


Subject
Views
Written By
Posted
DB Size Doesn't Decrease After Dropping Tables
3556
October 06, 2007 03:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.