mariadb存储引擎mysql_MariaDB10之TokuDB存储引擎

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

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

压缩比&＃xff1a;

EngineCompressionTable size [MB]

InnoDB none 2272

InnoDB KEY_BLOCK_SIZE&＃61;8 1144

InnoDB KEY_BLOCK_SIZE&＃61;4 584

MyISAM none 1810

MyISAM compressed with myisampack 809

Archive default 211

TokuDB ZLIB 284

TokuDB LZMA 208

特性&＃xff1a;

FeatureArchiveMyISAM (compressed)InnoDBTokuDB

only INSERTsnoyesyes

Transactionsnonoyesyes

nonoyesyes

Indexesnoyesyesyes

Online DDLnonoyes *yes **

MariaDB10&＃xff0c;已经内嵌了TokuDB存储引擎&＃xff0c;安装超简单&＃xff0c;如下&＃xff1a;

调优&＃xff1a;

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简单的多&＃xff0c;只是有一些参数变化&＃xff0c;&＃xff0c;或者你直接使用默认参数&＃xff0c;也运行的良好。MariaDB [(none)]> show variables like &＃39;%tokudb%&＃39;;

&＃43;---------------------------------&＃43;-------------&＃43;

| Variable_name | Value |

&＃43;---------------------------------&＃43;-------------&＃43;

| 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 |

&＃43;---------------------------------&＃43;-------------&＃43;

39 rows in set (0.01 sec)

本文原创发布php中文网&＃xff0c;转载请注明出处&＃xff0c;感谢您的尊重&＃xff01;