【MySQL】TokuDB引擎

標籤：

參考：http://blog.sina.com.cn/s/blog_4673e6030102v46l.html

 

參考：http://hcymysql.blog.51cto.com/5223301/1431698

參考：http://blog.csdn.net/yueliangdao0608/article/details/21230627

參考：http://code.openark.org/blog/mysql/tokudb-configuration-variables-of-interest

參考：http://blog.itpub.net/22418990/viewspace-1251497/

官網說明：http://docs.tokutek.com/tokudb/tokudb-index-variables.html

 

官網說明：https://mariadb.com/kb/en/mariadb/tokudb-system-variables/#tokudb_pk_insert_mode

 

MariaDB 10版本編譯TokuDB引擎需要比較高的g++和cmake版本，暫沒有進行單獨編譯，後續再測試。

測試版本：Percona-Server-5.6.24-rel72.2-Linux.x86_64.ssl101.tar.gz

測試版本：Percona-Server-5.6.24-rel72.2-TokuDB.Linux.x86_64.ssl101.tar.gz

OS:Centos 6.2

#### 配置 ##### - path of TokuDB file - #> tokudb_data_dir> tokudb_log_dir> tokudb_tmp_dir# - variables of TokuDB engine - #> tokudb_cache_sizeThis variable configures the size in bytes of the TokuDB cache table. The default cache table size is 1/2 of physical memory. Tokutek highly recommends using the default setting if using buffered IO, if using direct IO then consider setting this parameter to 80% of available memory.> tokudb_directioWhen set to ON, TokuDB employs Direct IO rather than Buffered IO for writes. When using Direct IO consider increasing tokudb cache size from its default of 1/2 physical memory. The default values is OFF.> tokudb_commit_syncSession variable tokudb_commit_sync controls whether or not the transaction log is flushed when a transaction commits. The default behavior is that the transaction log is flushed by the commit.Setting this parameter to off may make the system run faster. However, transactions committed since the last checkpoint are not guaranteed to survive a crash.> tokudb_fsync_log_periodControls the frequency, in milliseconds, for fsync() operations. If set to 0 then the fsync() behavior is only controlled by the tokudb commit sync, which is on or off. The default values is 0.> tokudb_row_formattokudb_default, tokudb_zlib: Use the zlib library,tokudb_fast, tokudb_quicklz: Use the quicklz library, the lightest compression with low CPU usage,tokudb_small, tokudb_lzma: Use the lzma library. the highest compression and highest CPU usagetokudb_uncompressed: No compression is used.http://docs.tokutek.com/tokudb/tokudb-index-using-tokudb.html#tokudb-compression-details> tokudb_read_buf_size> tokudb_loader_memory_size

 

【MySQL】TokuDB引擎