Mysql storage engine [Reading Notes 2]

Mysql storage engine [Reading Notes 2] storage engine (reference): it refers to how to store data, how to create indexes for stored data, and how to update and query data. Because in relational databases, data is stored as tables, the storage engine can also be called the table type (that is, the type of storing and operating the table ). Www.2cto.com 1, mysql storage engine: 1, MyISAM: 1), each table stores the physical files named after the table: stores the table structure definition information (. frm) to store table data (. MYD), store the table index (. MYI) 2), supports index types, B-Tree indexes (), R-Tree indexes (), Full-text indexes 2, Innodb; 1), and supports transaction installation, multi-version Data Reading, row lock through indexing, foreign key 2), physical data structure ①, data files (table data and index data) ②, innodb log file... 3. NDB Cluster 4 and Merge provide a single access portal 5 and Memory for MyISAM tables with the same structure through some special packages to access the data storage engine in the Memory, no data is stored on the disk. Only the table structure information (. frm) stored on disk 6, DBD 7, FEDERATED 8, ARCHIVE