Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

up vote 2 down vote accepted

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.