MariaDB10 TokuDB storage engine

The TokuDB storage engine, which can be seen as an upgraded version of the ARCHIVE storage engine, has intensive compression and supports transactions. Compression ratio: EngineCompressionTablesize [MB] InnoDBnone2272InnoDBKEY

The TokuDB storage engine, which can be seen as an upgraded version of the ARCHIVE storage engine, has intensive compression and supports transactions. Compression ratio: EngineCompressionTablesize [MB] InnoDBnone2272InnoDBKEY

The TokuDB storage engine, which can be seen as an upgraded version of the ARCHIVE storage engine, has intensive compression and supports transactions.

Compression ratio:

EngineCompressionTable size [MB]

InnoDB none 2272

InnoDB KEY_BLOCK_SIZE = 8 1144

InnoDB KEY_BLOCK_SIZE = 4 584

MyISAM none 1810

MyISAM compressed with myisampack 809

Archive default 211

TokuDB ZLIB 284

TokuDB LZMA 208

Features:

FeatureArchiveMyISAM (compressed) InnoDBTokuDB

Only INSERTsnoyesyes

Transactionsnonoyesyes

Nonoyesyes

Indexesnoyesyesyes

Online DDLnonoyes * yes **

MariaDB10 has been embedded with the TokuDB storage engine. The installation is extremely simple, as shown below:

Optimization:

Configuration: what's really important

As noted by Vadim long ago, "Tuning of TokuDB is much easier than InnoDB, there're only a few parameters to change, and actually out-of-box things running pretty well":
The optimization of TokuDB is much easier than that of InnoDB, but there are some parameter changes, or you can directly use the default parameter, it also runs well.

MariaDB [(none)]> show variables like '% tokudb % '; + bytes + ------------- + | Variable_name | Value | + bytes + ------------- + | bytes | OFF | tokudb_analyze_time | 5 | tokudb_block_size | 4194304 | bytes | 120926208 | tokudb_checkpoint_lock | OFF | metric | OFF | metric | 60 | metric | 5 | metric | 1 | tokudb_commit_sync | ON | tokudb_create_index_online | ON | tokudb_data_dir | tokudb_debug | 0 | tokudb_directio | OFF | fail | OFF | tokudb_disable_prefetching | OFF | fail | OFF | tokudb_empty_scan | rl | fail | 5 | fail | 0 | fail | ON | metric | 11403457 | tokudb_killed_time | 4000 | metric | tokudb_load_save_space | ON | metric | 100000000 | tokudb_lock_timeout | 4000 | metric | 1 | tokudb_log_dir | metric | 15115776 | metrics | 1 | metrics | ON | metrics | 65536 | metrics | 131072 | metrics | 10000 | tokudb_row_format | tokudb_zlib | tokudb_tmp_dir | tokudb_version | 7.1.6 | tokudb_write_status_frequency | 1000 | + --------------------------------- + ------------- + 39 rows in set (0.01 sec)