Enabling InnoDB with a MySQL table
The default storage engine for WebEnabled vhosts is MyISM. The reason for this is because most applications use MyISM and InnoDB requires a lot more storage and memory. If you need to use InnoDB as a storage engine then you currently have two options.
- CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;
- ALTER customers ENGINE = InnoDB;