Products & Services‎ > ‎MySQL‎ > ‎MySQL Administrator‎ > ‎

DBA Tips and Trick

Making InnoDB as a Default Table Type

Add the following line at /etc/my.cnf (for ubuntu users) on the mysqld section : 

default-storage-engine=InnoDB
default-table-type=InnoDB

This is valid for MySQL version < 5.5, for version 5.5 MySQL by default already using InnoDB.[1] 

Comments