Storage engine of a database refers to the type of tables and determines how tables are stored in computers. Although MySQL supports different types of storage engines, not all of them have been optimized for data restoration and persistence. TencentDB for MySQL features such as point-in-time restoration and snapshot restoration require a restoration-enabled storage engine and are available in the InnoDB storage engine only.
TencentDB for MySQL supports InnoDB by default. It no longer supports the MyISAM and Memory engines in MySQL 5.6 and higher mainly for the following reasons:
Note:
- With the widest lock scope, table-level locking is to lock the entire table that is being manipulated in MySQL.
- With the narrowest lock scope, row-level locking is to lock only the row that is being manipulated in MySQL.
For more information, please see InnoDB Overview and MyISAM Overview.
Was this page helpful?