Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
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 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


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.