Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
> Sent: Friday, February 11, 2011 12:17 AM
> To: mysql@lists.mysql.com
> Subject: Doubt Regarding Truncate
>
> Dear all,
>
> Today I performed the below commands on a 553 GB InnoDb table .
>
> truncate table page_c
sage-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Friday, February 11, 2011 12:17 AM
To: mysql@lists.mysql.com
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_cra
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%
