Features of various MySql storage engines

The following describes the features of several common storage engines and compares the differences and recommended usage methods between different storage engines. Features: MyisamBDBMemoryInnoDBArchive storage restrictions: No, 64 TB, no transaction security support: Lock machine tabulation lock page lock table lock row lock B-tree index support

The following describes the features of several common storage engines and compares the differences and recommended usage methods between different storage engines. Features Myisam BDB Memory InnoDB Archive storage limit no No 64 TB no transaction security support lock mechanism Table lock page lock table lock row lock B tree index support

The following describes the features of several common storage engines and compares the differences and recommended usage methods between different storage engines.

Features	Myisam	BDB	Memory	InnoDB	Archive
Storage restrictions	No	No	Yes	64 TB	No
Transaction Security	Supported	Supported
Lock Mechanism	Table lock	Page lock	Table lock	Row lock	Row lock
B-Tree Index	Supported	Supported	Supported	Supported	& Nbs...

Read the full text>

Related logs:

Differences between PHP empty (), isset () and is_null ()

10 suggestions for optimizing MySQL statements [go]

Introduction to the xml reading method in PHP

MySQL faces NoSQL challenges in the web application field [News]

Mysql InnoDB Storage engine details