当前位置：网站首页>MySQL storage engine

MySQL storage engine

First of all, let's understand Mysql The logical structure of adjoining course -> Service layer -> Engine layer -> Storage layer

see Mysql Support Engine

show ENGINE

engine	supper	Comment	Transactions	XA	Savepoints
InnoDB	DEFAULT	Supports transactions, row-level locking, and foreign keys	YES	YES	YES
MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO
MEMORY	YES	Hash based, stored in memory, useful for temporary tables	NO	NO	NO
BLACKHOLE	YES	/dev/null storage engine (anything you write to it disappears)	NO	NO	NO
MyISAM	YES	MyISAM storage engine	NO	NO	NO
CSV	YES	CSV storage engine	NO	NO	NO
ARCHIVE	YES	Archive storage engine	NO	NO	NO

View the default storage engine and the current storage engine

show variables like '%storage_engine%'

Variable_name	Value
default_storage_engine	InnoDB
default_tmp_storage_engine	InnoDB
disabled_storage_engines
internal_tmp_disk_storage_engine	InnoDB

Contrast item	MyISAM	InnoDB
Main foreign key	I won't support it	Support
Business	I won't support it	Support
Row table lock	Table locks	Row lock
cache	Store cache only , Don't store real data	Not only store cache indexes , Also store cache and real data , High memory requirements , And memory size can determine efficiency
Table space	Small	Big
concerns	performance	Business