Shulou(Shulou.com)05/31 Report--

This article mainly introduces the example analysis of MySQL5.6 installation parameter file, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

# MySQL_version 5.6.26

# Version 1.1

# Date 2016-03-31

# The MySQL server

[mysqld]

Port = 5626

User = my5626

Datadir = / data/mysql5626

Tmpdir = / dev/shm

Slave-load-tmpdir = / tmp

Socket = / tmp/mysql5626.sock

Key_buffer_size = 128m

Max_allowed_packet = 16m

# table_cache = 2048

Join_buffer_size = 16m

Sort_buffer_size = 16m

Read_buffer_size = 16m

Read_rnd_buffer_size = 32m

Myisam_sort_buffer_size = 128m

Query_cache_size = 256m

Query_cache_limit = 8m

Max_tmp_tables = 256

Tmp_table_size = 128m

Max_heap_table_size = 128m

Thread_cache_size = 64

Thread_concurrency = 32

Max_connect_errors = 99999999

Long_query_time = 1

Slow-query-log = 1

Slow-query-log-file = slow.log

Back_log = 600,

Myisam_repair_threads = 1

Myisam_recover_options = force,backup

Expire_logs_days = 10

Interactive_timeout = 30

Wait_timeout = 30

# old_passwords=1

Skip-slave-start = 1

Skip-name-resolve

Max_user_connections = 4000

Max_connections = 5000

Character-set-server = utf8

Read_only = 1

Log-slave-updates = 0

#-innodb-

Default-storage-engine = InnoDB

Innodb_buffer_pool_size = 5G

Innodb_additional_mem_pool_size = 32m

Innodb_data_file_path = ibdata1:100M:autoextend

Innodb_flush_log_at_trx_commit = 0

Innodb_log_buffer_size = 8m

Innodb_log_file_size = 1300m

Innodb_log_files_in_group = 3

Innodb_max_dirty_pages_pct = 90

Innodb_lock_wait_timeout = 20

Innodb_file_per_table = 1

Innodb_flush_method = O_DIRECT

Innodb_support_xa = 0

Innodb_io_capacity = 500,

Innodb_buffer_pool_instances = 10

Server-id = 016205624

Log-bin = mysql-bin

Relay-log = relay-bin

Log-error = error.log

[client]

User = mysqlha

Password = xxx

Port = 5626

Socket = / tmp/mysql5626.sock

No-auto-rehash

[myisamchk]

Key_buffer = 64m

Sort_buffer_size = 32m

Read_buffer = 16m

Write_buffer = 16m

The above is all the contents of the article "sample Analysis of MySQL5.6 installation parameters File". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.