TOKUDB Engine Notes

[Client]
Port = 3306
Socket =/tmp/mysql.sock

[Mysqld]
Port = 3306
Socket =/tmp/mysql.sock
Skip-external-locking
Max_allowed_packet = 1M
Myisam_sort_buffer_size = 64M
Thread_cache_size = 8
Query_cache_size= 16M
Open_files_limit = 8192
Max_connect_errors = 100000
Table_open_cache = 2048
Table_definition_cache = 2048
Max_heap_table_size = 96M
Sort_buffer_size = 2M
Join_buffer_size = 2M
Tmp_table_size = 96M
Key_buffer_size = 8M
Read_buffer_size = 2M
Read_rnd_buffer_size = 16M
Bulk_insert_buffer_size = 32M
Thread_concurrency = 8
DataDir =/data/mysql
Basedir =/usr/local/mysql

############# #tokudb ##########################
Plugin-load = Ha_tokudb
Tokudb_cache_size = 4G
Tokudb_data_dir =/data/mysql/tokudb_data
Tokudb_log_dir =/data/mysql/logs
Tokudb_tmp_dir =/data/mysql/tmp
Tokudb_pk_insert_mode = 2
Tokudb_commit_sync = 0
Tokudb_directio = 1
Tokudb_read_block_size = 128K
Tokudb_read_buf_size = 128K
Tokudb_row_format = Tokudb_fast
############## #innodb ######################
Innodb_buffer_pool_size = 1G
Innodb_buffer_pool_instances = 1
#innodb_data_file_path = Ibdata1:1g:autoextend
Innodb_flush_log_at_trx_commit = 1
Innodb_log_buffer_size = 64M
Innodb_log_file_size = 256M
Innodb_log_files_in_group = 2
innodb_file_per_table = 1
Innodb_status_file = 1
Transaction_isolation = read-committed
Innodb_flush_method = O_direct

Log-bin=mysql-bin
Binlog_format=mixed
Server-id = 1

[Mysqldump]
Quick
Max_allowed_packet = 16M

[MySQL]
No-auto-rehash

[Myisamchk]
Key_buffer_size = 128M
Sort_buffer_size = 128M
Read_buffer = 2M
Write_buffer = 2M

[Mysqlhotcopy]
Interactive-timeout

Description of each parameter:
Tokudb_cache_size
By default, Tokudb allocates 50% of the system's physical memory.
Tokudb_data_dir
Specifies the location where the TOKUDB data is stored. The default is null, using the path defined by DataDir.
Tokudb_log_dir
Specifies the location where the Tokudb log is stored. The default is null, using the path defined by DataDir.
Tokudb_tmp_dir
Tokudb the location where temporary files are stored when you bulk import data. TOKUDB uses load data to import data through temporary tables (which can be very large).
The default is null, using the path defined by DataDir.
Tokudb_pk_insert_mode
The primary key is written in a mode that supports RBR only if the value is 2 o'clock.

This article is from the "Boyhack" blog, make sure to keep this source http://461205160.blog.51cto.com/274918/1910078

TOKUDB Engine Notes