I have MySQL database with tables on InnoDB engine. But server is configured to use only one file ibdata0 without parameter innodb_file_per_table. I want to change this without making dump and restore ...
If I turn on innodb_file_per_table (not currently active), will it destroy my existing tables?
I already created a mysql database. However, for my future tables that I create, I want to default to INNODB
How can default to INNODB for every table to create in the future?
In particular, how do you choose between MyISAM and InnoDB, when neither is missing a required feature (e.g. you don't need foreign keys). Does it always come down to trying both and measuring? Or ...