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
