MySQL manages tables using storage engines, each of which handles tables that have a given set of characteristics. Different storage engines have differing performance characteristics, and can be chosen based on which engine most closely matches the char acteristics that are needed. For example, a table may require transactional capabilities and guaranteed data in tegrity even if a crash occurs, or it may require a very fast lookup table stored in memory for which the contents can be lost in a crash and reloaded at the next server startup. With MySQL, these choices can be made on a per-table basis. Any given table is managed by a particular storage engine. Options can be added to the CREATE TABLE command in order to control the manner in which the entire table is handled. ENGINE={MyISAM | InnoDB | MEMORY} Indicates the storage engine to be used for the table MyISAM is the default storage engine (unless --default-storage-engine has been set) COM...
“The best way to be ready for the future is to invent it.”— John Sculley