MySQL-supported storage engine (minimalist version)

2. 1 InnoDB (not verbose)
   

4. Archive supports high concurrent inserts and dedicated buffered row-level locks

6. Blackhole can be used to copy data to a repository, or to log. Do not save any

8. CSV does not support indexing, it is easy to structure CSV use
   

10. Federated connecting to other MySQL agents

12. Memory

    1. Usage Scenarios

       1. For finding or mapping tables

       2. Save intermediate data in data analysis

       3. Results for caching of periodic aggregated data

14. NDB Cluster engine

16. An improved version of XtraDB InnoDB, the main improvement is performance scalability and operational flexibility

18. The PBXT supports the engine-level replication foreign key constraints, and provides the appropriate support for solid state storage SSDs with a complex architecture optimized for blobs. MARIADB also contains this engine

20. Infobright is a column-oriented storage engine. is designed for data analysis and data warehousing. Data is compressed, sorted by block, and each bucket should have a set of data.

22. MyISAM

    1. compression, full-text indexing, GIS spatial functions

    2. Transaction and row-level locks are not supported and cannot be fully recovered

    3. Data files (MYD) and index files (MYI)

This article is from the "GUI Floral" blog, please be sure to keep this source http://1074963.blog.51cto.com/1064963/1747312

MySQL-supported storage engine (minimalist version)