List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:February 11 2011 5:20am
Subject:RE: Doubt Regarding Truncate
View as plain text  
Do you have innodb_file_per_table turned on ???

If this is off, then all your InnoDB data is going in /var/lib/mysql/ibdata1

You actually need to the following to recover all free space from all InnoDB tables

I commented on this in
http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#4056261


Rolando A. Edwards
MySQL DBA (SCMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwards@stripped
http://www.linkedin.com/in/rolandoedwards

-----Original Message-----
From: Adarsh Sharma [mailto:adarsh.sharma@stripped] 
Sent: Friday, February 11, 2011 12:17 AM
To: mysql@stripped
Subject: Doubt Regarding Truncate

Dear all,

Today I performed  the below commands on a 553 GB InnoDb table .

truncate table page_crawled;
optimize table page_crawled;

But I couldn't find the free space available after truncation.  The 
below structure is  same as before  truncation


/dev/sda2              29G  9.5G   18G  36% /
/dev/sda1              99M   11M   84M  11% /boot
/dev/sda5              69G   35G   32G  52% /hdd1-1
/dev/sdb1             274G  225G   36G  87% /hdd2-1
/dev/sdc5             274G  225G   36G  87% /hdd3-1
/dev/sdd5             274G  212G   49G  82% /hdd4-1
/dev/sde1             266G  161G   92G  64% /hdd5-1

Please guide me if I 'm doing something wrong.


Thanks & best Regards

Adarsh Sharma


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Doubt Regarding TruncateAdarsh Sharma11 Feb
  • RE: Doubt Regarding TruncateRolando Edwards11 Feb
    • Re: Doubt Regarding TruncateClaudio Nanni11 Feb