"MySQL" Tokudb engine

Reference: http://blog.sina.com.cn/s/blog_4673e6030102v46l.html

Reference: http://hcymysql.blog.51cto.com/5223301/1431698

Reference: http://blog.csdn.net/yueliangdao0608/article/details/21230627

Reference: Http://code.openark.org/blog/mysql/tokudb-configuration-variables-of-interest

Reference: http://blog.itpub.net/22418990/viewspace-1251497/

Website Description: http://docs.tokutek.com/tokudb/tokudb-index-variables.html

Website Description: https://mariadb.com/kb/en/mariadb/tokudb-system-variables/#tokudb_pk_insert_mode

MariaDB 10 build Tokudb engine requires relatively high g++ and cmake versions, and is not compiled separately, subsequent re-testing.

Beta version: percona-server-5.6.24-rel72.2-linux.x86_64.ssl101.tar.gz

Beta version: percona-server-5.6.24-rel72.2-tokudb.linux.x86_64.ssl101.tar.gz

Os:centos 6.2

# # # config #####-Path ofTokudbfile - #>Tokudb_data_dir>Tokudb_log_dir>tokudb_tmp_dir#-Variables ofTOKUDB engine- #>tokudb_cache_sizethis variable configures the sizeinchbytes ofThe TOKUDB cacheTable. ThedefaultCacheTableSize is 1/2  ofPhysical memory. Tokutek highly recommends using thedefaultSettingifUsing buffered IO,ifUsing Direct IO ThenConsider setting this parameter to  the%  ofavailable memory.>Tokudb_directio when Set  to  on, TOKUDB employs Direct io rather than Buffered IO forWrites. whenUsing Direct IO Consider increasing tokudb cache size fromItsdefault  of 1/2Physical memory. Thedefault Values  is OFF.>tokudb_commit_syncsession Variable Tokudb_commit_sync controls whetheror  notTheTransaction Log  isFlushed whenATransactionCommits. ThedefaultBehavior isthat theTransaction Log  isFlushed byTheCommit. Setting This parameter to offMay make the system run faster. However, transactionscommittedSince the lastCheckpointIs notGuaranteed tosurvive a crash.>tokudb_fsync_log_periodcontrols the frequency,inchMilliseconds forFsync () operations.If Set  to 0  ThenThe Fsync () behavior is  onlyControlled byThe TokudbCommitSync, which is  on or if. Thedefault Values  is 0.>Tokudb_row_formattokudb_default, Tokudb_zlib: Usethe zlib library,tokudb_fast, Tokudb_quicklz: UseThe Quicklz library, the lightest compression withLow CPU Usage,tokudb_small, Tokudb_lzma: UseThe Lzma library. The highest compression andhighest CPU usagetokudb_uncompressed:no compression isused.http://Docs.tokutek.com/Tokudb/Tokudb-Index-Using-Tokudb.html#tokudb-Compression-Details>tokudb_read_buf_size>Tokudb_loader_memory_size

"MySQL" Tokudb engine