I have a ibdata file and i have 3 databases. In one of them i had tables with size around 10 GB, each one.
Now i made a truncate for both tables but the space in the ibdata file never shrinks.
I ran a optimize table, alter table and the ibdata size looks the same.
How can i shrinks ibdata file without make a dump a restore again?
Thanks for your help.