To check the current support Mysql types.
mysql> show engines;
+————+———-+—————————————————————-+
| Engine | Support | Comment |
+————+———-+—————————————————————-+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level locking |
This implies, InnoDB has been enabled by default. You can disable this by adding the following line in my.cnf and restart mysql.
skip-innodb
Once InnoDB is enabled, you can make it the default table type by specifying the following in /etc/my.cnf:
default-table-type=innodb
Posted by We3cares 