Home / server / Questions / 93559
Accepted
Alex
Asked: 2009-12-12 13:53:15 +0800 CST

How do I set the default table type as innodb in my.cnf?

  • 772

For mysql...is there a way to set it so that every table that gets created is innodb?

mysql

3 Answers

  1. Best Answer

    Edit your my.cnf file to set following in the [mysqld] section (or the section your MySQLd reads):

    default-storage-engine=InnoDB

    After restarting the MySQL server, InnoDB should be the new default. To verify this, run the SQL statement:

    SHOW ENGINES;

    ...The InnoDB line should be indicated as DEFAULT.

    Note that the default-storage-engine option is just an alternate name for default-table-type.

    • 12

  2. Yes, you can

    default-storage-engine=InnoDB

    default-table-type=InnoDB

    • 1

  3. I want to my Clustered Node to work like when I create a new database It won't get replicated. Normally after having the above mentioned attribute set 'default-storage-engine=INNODB', When I create a table without mentioning the engine it is not replicated to the other node, that is fine. But Why does the database gets created on other nodes?

    • 0