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=arch...@jab.org

Reply via email to