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.

  1. CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;
  2. ALTER customers ENGINE = InnoDB;

PLEASE READ: At this time we require a special request for InnoDB to be enabled per application. Please contact us and make a request for the InnoDB storage engine to be activated on the specific application you intend to use it on.