mysql tokudb引擎_TokuDB引擎笔记

[client]port        = 3306socket      = /tmp/mysql.sock[mysqld]port        = 3306socket      = /tmp/mysql.sockskip-external-lockingmax_allowed_packet = 1Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size= 16Mopen_files_limit = 8192max_connect_errors = 100000table_open_cache = 2048table_definition_cache = 2048max_heap_table_size = 96Msort_buffer_size = 2Mjoin_buffer_size = 2Mtmp_table_size = 96Mkey_buffer_size = 8Mread_buffer_size = 2Mread_rnd_buffer_size = 16Mbulk_insert_buffer_size = 32Mthread_concurrency = 8datadir = /data/mysqlbasedir = /usr/local/mysql##############tokudb##########################plugin-load = ha_tokudbtokudb_cache_size = 4Gtokudb_data_dir = /data/mysql/tokudb_datatokudb_log_dir = /data/mysql/logstokudb_tmp_dir = /data/mysql/tmptokudb_pk_insert_mode = 2tokudb_commit_sync = 0tokudb_directio = 1tokudb_read_block_size = 128Ktokudb_read_buf_size = 128Ktokudb_row_format = tokudb_fast###############innodb######################innodb_buffer_pool_size = 1Ginnodb_buffer_pool_instances = 1#innodb_data_file_path = ibdata1:1G:autoextendinnodb_flush_log_at_trx_commit = 1innodb_log_buffer_size = 64Minnodb_log_file_size = 256Minnodb_log_files_in_group = 2innodb_file_per_table = 1innodb_status_file = 1transaction_isolation = READ-COMMITTEDinnodb_flush_method = O_DIRECTlog-bin=mysql-binbinlog_format=mixedserver-id   = 1[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash[myisamchk]key_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout各参数说明：tokudb_cache_size默认情况下，TokuDB分配50%的系统物理内存。tokudb_data_dir指定TokuDB数据的存储位置。默认为空，使用datadir定义的路径。tokudb_log_dir指定TokuDB日志的存储位置。默认为空，使用datadir定义的路径。tokudb_tmp_dirTokuDB批量导入数据时，临时文件的存储位置。TokuDB在使用LOAD DATA导入数据的时候会通过临时表(可能会很大)来完成。默认为空，使用datadir定义的路径。tokudb_pk_insert_mode

主键写入的模式，只有值为2时，才支持RBR。

本文转自 boy461205160 51CTO博客，原文链接:http://blog.51cto.com/461205160/1910078