I am new to mysql DB and want to know how to reclaim space.
I am currently using Innodb table and I deleted data and ran optimize query but for some reason it gave "Table does not support optimize, doing recreate + analyze instead"

Also, if I use Truncate and drop table will it free space ?

Thank you!