Shulou(Shulou.com)06/01 Report--

[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 TokuDB data is stored. The default is empty and the path defined by datadir is used.

Tokudb_log_dir

Specifies the location where the TokuDB logs are stored. The default is empty and the path defined by datadir is used.

Tokudb_tmp_dir

The location where temporary files are stored when TokuDB imports data in bulk. TokuDB does this through temporary tables (which can be large) when importing data using LOAD DATA.

The default is empty and the path defined by datadir is used.

Tokudb_pk_insert_mode

The mode written by the primary key supports RBR only if the value is 2.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.