当前位置:Gxlcms > mysql > MariaDB10之TokuDB存储引擎

MariaDB10之TokuDB存储引擎

时间:2021-07-01 10:21:17 帮助过:39人阅读

TokuDB存储引擎,你可以把它看做是ARCHIVE存储引擎的升级版,它拥有了密集压缩,并且支持事务。压缩比:EngineCompressionTablesize[MB]InnoDBnone2272InnoDBKEY

TokuDB存储引擎,你可以把它看做是ARCHIVE存储引擎的升级版,它拥有了密集压缩,并且支持事务。


压缩比:

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


特性:

FeatureArchiveMyISAM (compressed)InnoDBTokuDB

only INSERTsnoyesyes

Transactionsnonoyesyes

nonoyesyes

Indexesnoyesyesyes

Online DDLnonoyes *yes **


MariaDB10,已经内嵌了TokuDB存储引擎,安装超简单,如下:

wKiom1OtPlfCi288AAKnwHfPFQI258.jpg

wKiom1OtM0XAGza2AAHWxjkDGtQ067.jpg

wKioL1OtMxeBeePWAAHBl7c2-ic775.jpg

wKiom1OtM0WD21kHAALMk2W8OOQ524.jpg


调优:

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“:
TokuDB调优比InnoDB简单的多,只是有一些参数变化,,或者你直接使用默认参数,也运行的良好。

MariaDB [(none)]> show variables like '%tokudb%'; +---------------------------------+-------------+ | Variable_name | Value | +---------------------------------+-------------+ | tokudb_alter_print_error | OFF | | tokudb_analyze_time | 5 | | tokudb_block_size | 4194304 | | tokudb_cache_size | 120926208 | | tokudb_checkpoint_lock | OFF | | tokudb_checkpoint_on_flush_logs | OFF | | tokudb_checkpointing_period | 60 | | tokudb_cleaner_iterations | 5 | | tokudb_cleaner_period | 1 | | tokudb_commit_sync | ON | | tokudb_create_index_online | ON | | tokudb_data_dir | | | tokudb_debug | 0 | | tokudb_directio | OFF | | tokudb_disable_hot_alter | OFF | | tokudb_disable_prefetching | OFF | | tokudb_disable_slow_alter | OFF | | tokudb_empty_scan | rl | | tokudb_fs_reserve_percent | 5 | | tokudb_fsync_log_period | 0 | | tokudb_hide_default_row_format | ON | | tokudb_init_flags | 11403457 | | tokudb_killed_time | 4000 | | tokudb_last_lock_timeout | | | tokudb_load_save_space | ON | | tokudb_loader_memory_size | 100000000 | | tokudb_lock_timeout | 4000 | | tokudb_lock_timeout_debug | 1 | | tokudb_log_dir | | | tokudb_max_lock_memory | 15115776 | | tokudb_pk_insert_mode | 1 | | tokudb_prelock_empty | ON | | tokudb_read_block_size | 65536 | | tokudb_read_buf_size | 131072 | | tokudb_read_status_frequency | 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)

人气教程排行