MySQL's database storage engine

First, the database storage engine Introduction

The database storage engine is the database's underlying software component, and the database management system (DBMS) uses the database storage engine to create, query, update, and delete data operations. Different storage engines provide different

Storage mechanisms, indexing techniques, locking levels, and other features that use different storage engines, and that can also be used for specific functions.

Second, MySQL database storage engine Introduction

MySQL provides a number of different storage engines, including the engine that handles transaction security tables and the engine that handles non-transactional security tables. In MySQL, there is no need to use a single storage engine across the server for

Specific business and scenarios, you can use a different storage engine for each table. The storage engines supported in Mysql5.7 are: InnoDB, MyISAM, Memory, Merge, Archive, Federated, CSV, Blackhole, etc.

1. Use the show engines statement to see which engine types are supported by the system

　　

Mysql> Show engines\g;*************************** 1. Row *************************** Engine:mrg_myisam support:yes comment:collection of identical MYISAM table Stransactions:no Xa:no savepoints:no*************************** 2.          Row *************************** engine:csv support:yes comment:csv Storage Enginetransactions:no Xa:no savepoints:no*************************** 3.  Row *************************** Engine:myisam Support:default comment:default Engine as of MySQL 3.23 with Great Performancetransactions:no xa:no savepoints:no*************************** 4. Row *************************** Engine:innodb support:yes comment:supports transactions, Row-level locking , and foreign Keystransactions:yes xa:yes savepoints:yes*************************** 5.  Row *************************** engine:memory Support:yes comment:hash based, stored in MEMORY, useful for TeMporary tablestransactions:no xa:no savepoints:no5 rows in Set (0.00 sec) error:no Query specified#support column Value indicates whether the storage engine supported by the current database management system can be used: Yes indicates that it can be used, and no indicates that it cannot be used. Default means that the storage engine is the storage engine used by the database management system

　　

Three, InnoDB storage engine Features

InnoDB is the preferred storage engine for transactional databases, supports transaction security tables, supports row locking and foreign keys, and InnoDB provides MySQL with a transaction-safe storage engine with commit, rollback, and crash resiliency . InnoDB locks the row level and also provides an oracle-like non-locking read in the Select statement, increasing multiuser deployment and performance

Four, MyISAM storage engine Features

MyISAM is a ISAM-based storage engine and extends it. It is one of the most commonly used storage engines in the Web, data storage, and other application environments.  The MyISAM has high insertion, query speed, but no transaction support.

MySQL's database storage engine