How can default to INNODB for every table to create in the future?
2 Answers
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.
...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.