0
votes
1answer
797 views

Safe conversion from one InnoDB(ibdata) file to innodb file per table

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 ...
1
vote
2answers
431 views

Switching To `innodb_file_per_table` In MySQL

If I turn on innodb_file_per_table (not currently active), will it destroy my existing tables?
2
votes
2answers
85 views

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?
16
votes
5answers
3k views

How do you choose a MySQL database engine

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 ...