Shulou(Shulou.com)05/31 Report--

This article will explain in detail what MySQL extended storage engine has, the quality of the article content is high, so Xiaobian shares it for everyone to make a reference, I hope you have a certain understanding of relevant knowledge after reading this article.

Here are a few column storage engines:

1: TokuDB

TokuDB is a high performance, transactional MySQL and MariaDB storage engine. TokuDB's main feature is support for high write pressures.

TokuDB v7 has been released.

TokuDB is announced as open source, an open source community version that provides full functionality and performance, downtime free column additions, deletions, and renames, as well as index creation, and secondary primary keys for clusters. The Enterprise version has also been upgraded to include additional support packs and advanced backup and recovery tools.

Tokudb uses indexes to speed up queries, has high scalability, and supports hot scheme modification.

Features:

1. Insertion performance is 20~80 times faster;

2. Compressing data reduces storage space;

3. Data volumes can scale to several TB;

4. No index fragmentation;

5. Support hot column addition, hot indexing, mvcc;

How to consider using:

1. If you want to store blobs, don't use tokuDB because its records can't be too large;

2. If the number of records exceeds 100 million, use tokuDB;

3. If you pay attention to update performance, do not use tokuDB, it is not as fast as innodb;

4. If you want to store old records, use tokuDB;

5. If you want to reduce the storage space occupied by data, use tokuDB;

Infobrigh (infobright community version only supports load data operation, no online hot standby tool, community version does not support DML)

Infobright is an open source MySQL data warehouse solution that introduces column storage schemes, intensive data compression, optimized statistical computation (like sum/avg/group by),

Infobright is based on mysql, but it can be installed without mysql, because it comes with one. MySQL can be roughly divided into logical layer and physical storage engine, infobright mainly implements a storage engine, but because its own storage logic is fundamentally different from relational database, it cannot be directly attached to mysql as a plug-in like InnoDB, its logical layer is mysql logical layer plus its own optimizer.

1, high compression ratio, the average compression ratio can reach 10:1, even up to 40:1, I use infobright to save 3.1G data to less than 300M.

2, column storage, even if the amount of data is very large, query speed is also very fast. For data warehouse, processing massive data without a set can not do.

3, do not need to build an index, to avoid the maintenance index and index with the data expansion problem. Each column of data is compressed and stored in blocks, and each grid node with knowledge records the statistical information in the block instead of the index to accelerate the search.

A single server can efficiently read and write 30T data. Scalability, which means that for the same query, when the data volume is 10T, it should not take much slower than 1T data volume, basically within an order of magnitude.

Disadvantages and Limitations of Community Edition:

1. DML not supported 2. Multicore not supported 3. Distributed not supported

3: InfiniDB

InfiniDB: InfiniDB Community Edition provides a scalable, analytical database engine developed primarily for data warehousing, business intelligence, and applications that are not critical of real-time performance. Based on MySQL. Includes support for queries, transactions, and large data loads. There are not many users right now.

Engine Selection Recommendations:

1. Preferred Innodb

2. Second, TokuDB and InfiniDB are recommended.

What about MySQL extended storage engine to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.