List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:February 11 2011 10:02am
Subject:Re: Doubt Regarding Truncate
View as plain text  
The only case in which you recover automatically the disk space is with
MyISAM tables,
In case of other storage engines is depending on the specific engine.
And the only guaranteed way to have new optimized tables is *full* dump and
reload.

Rolando link is good.

Cheers

Claudio

2011/2/11 Rolando Edwards <redwards@stripped>

> 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/405si
> si martino, masturbiamo dopo
> insieme!6261#4056261<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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Claudio

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