MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:February 11 2011 5:17am
Subject:Doubt Regarding Truncate
View as plain text  
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

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