MySQL Storage Engine

Introduction

The next few articles will detail several commonly used storage engines and the appropriate scenarios. This article will be the first to know about the MySQL storage engine.

Reference Note: mysql5.7

View supported storage engines

Mysql>show engines \g;*************************** 1. Row***************************Engine:innodb Support:DEFAULTcomment:supports transactions, Row- LevelLocking and Foreignkeystransactions:yes Xa:yes Savepoints:yes*************************** 2. Row***************************engine:csv support:yes comment:csv storage enginetransactions:no xa:no savepoints:no*************************** 3. Row***************************Engine:performance_schema Support:yes comment:performanceSchematransactions:no xa:no Savepoints:no*************************** 4. Row***************************engine:blackhole support:yes Comment:/Dev/NULLStorage engine (anything you write toit disappears) Transactions:no Xa:no Savepoints:no*************************** 5. Row***************************Engine:myisam support:yes comment:myisam storage enginetransactions:no xa:no savepoints: NO*************************** 6. Row***************************Engine:mrg_myisam Support:yes comment:collection ofidentical MyISAM tablestransactions:no xa:no savepoints:no*************************** 7. Row***************************engine:archive support:yes comment:archive storage enginetransactions:no xa:no savepoints : NO*************************** 8. Row***************************engine:memory Support:yes comment:hash based, storedinchMemory, useful for Temporarytablestransactions:no xa:no Savepoints:no*************************** 9. Row***************************engine:federated support:yes comment:federated MySQL storage Enginetransactions:no Xa:no Savepoints:no9Rowsinch Set(0.00Sec

The Supports column describes support (YES), does not support (no), and the current default storage engine.

Description of various storage engines

Summary

Starting from 5.7, the InnoDB storage engine becomes the default storage engine.

Note: pursuer.chen Blog:http://www.cnblogs.com/chenmh This site all the essays are original, welcome to reprint, but reprint must indicate the source of the article, and at the beginning of the article clearly give the link. Welcome to the exchange of discussions

MySQL Storage Engine