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

This article mainly introduces the advantages and disadvantages of TokuDB and what are the applicable scenarios. What is introduced in this article is very detailed and has a certain reference value. Interested friends must finish reading it!

Advantages of TokuDB:

High compression ratio. Zlib is used for compression by default, especially for strings (varchar,text, etc.). It is more suitable for storing logs, raw data, etc. Officials say it can reach 1:12.

Add indexes online without affecting read and write operations

HCADER feature, which supports online field addition, deletion, expansion and renaming operations (instant or second completion)

Support for complete ACID features and transaction mechanisms

Very fast write performance, Fractal-tree has an advantage in transaction implementation, no undo log, officially at least 9 times higher than innodb.

Support for show processlist progress check

The amount of data can be expanded to several TB

There is no index fragmentation.

Support for hot column addition,hot indexing,mvcc

Disadvantages of TokuDB:

The foreign key (foreign key) feature is not supported. If your table has a foreign key, this constraint will be ignored when you switch to the TokuDB engine.

TokuDB is not suitable for scenarios that are read heavily because of compression and decompression. The CPU footprint will be 2-3 times higher, but due to the small compressed space and low IO overhead, the average response time is about 2 times.

Online ddl is not applicable to fields such as text,blob.

There is no perfect hot backup tool, so logical backup can only be done through mysqldump.

Applicable scenarios:

Archiving of data or historical data that is not accessed frequently

The datasheet is very large and requires DDL operations from time to time

These are all the contents of this article entitled "what are the advantages and disadvantages and applicable scenarios of TokuDB?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.