471,108 Members | 1,302 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

release disk space by drop database ?

Hi all,

OS. linux 2.4.22
MYsql : 4.0.18-standard

I created a database and populate 2 big InnoDB tables, the total size
is > 3G. After all testing, I droped the database .

But, the harddisk space is not release to the filesystem, Why, How
could I recover that ?

Thanks.
Jul 20 '05 #1
1 3942
Section 14.2.8 DROP DATABASE Syntax of the online user manual has user
comments that imply foreign key constraints may prevent some or all
tables from being removed. One suggests issuing this:
SET FOREIGN_KEY_CHECKS = 0;
prior to the drop to avoid the problem.
MailSurfer wrote:
Hi all,

OS. linux 2.4.22
MYsql : 4.0.18-standard

I created a database and populate 2 big InnoDB tables, the total size
is > 3G. After all testing, I droped the database .

But, the harddisk space is not release to the filesystem, Why, How
could I recover that ?

Thanks.


Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by cover | last post: by
1 post views Thread by MailSurfer | last post: by
5 posts views Thread by Yasaswi Pulavarti | last post: by
2 posts views Thread by Massimiliano Campagnoli | last post: by
4 posts views Thread by sandip | last post: by
2 posts views Thread by James | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.