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