Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "which storage engines are supported by mysql". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

In mysql, the storage engine is the underlying software component of the database, which simply refers to the type of table, which determines how the table is stored in the computer. Different storage engines provide different storage mechanisms, indexing techniques, locking levels and other functions, and specific functions can be obtained using different storage engines.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

The database storage engine is the underlying software component of the database. The database management system uses the data engine to create, query, update and delete data. In short, the storage engine refers to the type of table.

The storage engine of the database determines how tables are stored in the computer. Different storage engines provide different storage mechanisms, indexing techniques, locking levels and other functions, and specific functions can be obtained using different storage engines.

In MySQL, the storage engine runs as a plug-in. MySQL provides several different storage engines, including an engine for transactional security tables and an engine for non-transactional security tables. In MySQL, you don't need to use the same storage engine throughout the server, and you can use a different storage engine for each table for specific requirements.

MySQL 5.7supports storage engines such as InnoDB, MyISAM, Memory, Merge, Archive, CSV, BLACKHOLE, etc. You can use the SHOW ENGINES; statement to view the types of engines supported by the system, and the result is shown in the figure.

The value of the Support column indicates whether an engine can be used, YES means it can be used, NO means it cannot be used, and DEFAULT indicates that the engine is the current default storage engine.

Several storage engines are briefly described below, and several of them (mainly InnoDB and MyISAM) will be explained in detail later. Things like NDB require more discussion of extensibility, which is beyond the scope of this tutorial, so I won't say much about them later in the tutorial.

Table 1 the storage engine of MySQL describes the engine used by ARCHIVE for data archiving. After the data is inserted, it cannot be modified and indexing is not supported. When CSV stores data, it uses commas as the delimiter between data items. BLACKHOLE discards the write operation, which returns empty content. FEDERATED stores data in a remote database, which is used to access the storage engine of remote tables. InnoDB transaction engine with foreign key support MEMORY tables placed in memory MERGE is used to manage a collection of tables made up of multiple MyISAM tables MyISAM's main non-transactional storage engine NDBMySQL cluster dedicated storage engine

Several storage engines have synonyms for their names. For example, MRG_MyISAM and NDBCLUSTER are synonyms for MERGE and NDB, respectively. The storage engines MEMORY and InnoDB were called HEAP and Innobase respectively in the early days. Although the last two names can still be recognized, they have been abandoned.

This is the end of the content of "which storage engines does mysql support". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.