how do I reduce size of ibd file in mysql directory

Viewed 6

I have a table that has an ibd table that is 14gigs. the data is useless to me so i deleted all the rows of that table.

the table.ibd file in the mysql directory is still 14 gigs after deletion and a mysql restart. How can i shrink that file?

0 Answers
Related