How to Convert InnoDB to innodb_file_per_table and Shrink ibdata1
- Written by Vanessa Vasile
- Published in Howto, MySQL, Scripts
- 12 Comments
Years ago, MySQL started allowing InnoDB to possess separate tablespace per table instead of a massive unified ibdata1 file. Tablespace is basically a logical storage area that contains table information – references, if you will. Every table, regardless of the storage engine, has one, and without it the table will be unrecognizable to MySQL. MyISAM stores…
Read more