What is the storage engineFor example, if you are working on a large amount of temporary data, you may need to use a memory storage engine. The memory storage engine can store all the tabular data in memory. Alternatively, you might need a database that supports transactional processing (to ensure that the data is backed up when transaction processing is unsuccessful). These different technologies and associated functions are called storage engines (also known as table Types ) in MySQL. MyISAM: High insertion, query speed, but no transaction supportinnodb:5.5 version after MySQL's default database, the preferred engine for transactional databases, supports acid transactions, supports row-level lockingBDB: Another option for transactional databases originating from Berkeley DB, supporting other transactional features such as commit and rollbackMemory : All data is placed into the storage engine, which has very high insertion, update and query efficiency. However, it occupies a memory space that is proportional to the amount of data. And its contents are lost when MySQL restartsMerge: Combine a certain number of MyISAM tables into a single unit that is useful for ultra-large data storageArchive: Ideal for storing large amounts of independent data as historical records. Because they are not often read. Archive has an efficient insertion speed, but its support for queries is relatively poorFederated: Combine different MySQL servers to logically make up a complete database. Ideal for distributed ApplicationsCLUSTER/NDB: A highly redundant storage engine that provides services in conjunction with multiple data machines to improve overall performance and security. Suitable for applications with high data volumes, security and performance requirementsCSV: A storage engine that logically divides data by commas. It creates one for each data table in the database subdirectory. CSV file. This is an ordinary text file, where each row of data occupies a line of text. The CSV storage engine does not support indexing. blackhole: Black hole engine, any data written will disappear, generally used to record binlog do replication relay In addition, MySQL's storage engine interface is well defined. Interested developers write their own storage engine by reading a document.
MySQL Storage engine
