2

How can default to INNODB for every table to create in the future?

0

2 Answers 2

2

Specify default_table_type in the my.cnf as such:

default_table_type = INNODB

Oddly enough, this may not be documented in MySQL's documentation. I have been using this configuration option for a long time and verified its performance again after not being able to find official reference material.

0

...be sure to look at innodb_file_per_table as well, by default it's 0 and will create all your tables in one huge datafile that will never go down in size, only up (even if you delete data - it's their design). Only by having your InnoDB tables in separate files can you shrink their sizes by 'optimize table' and such.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .