In this post, I am going to discuss MySQL InnoDB File-Per-Table tablespaces. What are the advantages and disadvantages? How to enable and disable it? By default, The InnoDB stores tables and indexes into the system tablespace. If we want to create separate .idb and .frm file for each table, we should enable innodb_file_per_table. How to … Continue reading MySQL: The Truth about InnoDB File Per Table Tablespaces