InnoDB1) Although the user is not supported to create a clustered index, INNODB will establish a clustered index on the primary key. If you do not specify a primary key, InnoDB replaces it with an index that has a unique and non-null value. If such an index does not exist, InnoDB defines a hidden primary key and then establishes a clustered index on it. In general, the DBMS stores the actual data in the form of a clustered index, which is the basis for other two-level indexes. The use of self-increasing primary key in InnoDB can achieve better efficiency. 2) using row-level locks3) Support concurrency4) Support Transactions5) Better safety than MyISAM
MyISAM1) The user is not supported to create a clustered index and does not use the clustered index store itself. 2) Only table-level locks are supported3) does not support transactions4) Query efficiency is higher than InnoDB5) Support full-text indexing, spatial indexing