mysql 5.6.36安装图解_Mysql5.6.36脚本编译安装及初始化教程

[mysqld]

basedir = /data/mysql

datadir = /data/mysql/data

tmpdir = /data/mysql

socket = /data/mysql/mysql.sock

skip-external-locking

skip-name-resolve

lower_case_table_names=1

auto_increment_offset = 1

auto_increment_increment = 2

#server-id

########## binlog ##########

log_bin = /data/mysql/logs/mysql-bin

binlog_format = row

binlog_cache_size = 2M

expire-logs-days = 7

########## error log ##########

log_error = /data/mysql/logs/mysql-error.log

########## slow log ##########

slow_query_log = 1

slow_query_log_file = /data/mysql/logs/mysql-slow.log

long_query_time = 5

########## per_thread_buffers ##########

max_connections = 1024

max_connect_errors = 1000

key_buffer_size = 64M

max_allowed_packet = 128M

table_open_cache = 6144

table_definition_cache = 4096

sort_buffer_size = 512K

read_buffer_size = 512K

join_buffer_size = 512K

tmp_table_size = 64M

max_heap_table_size = 64M

thread_cache_size = 64

thread_concurrency = 32

bulk_insert_buffer_size = 64M

########innodb########

innodb_buffer_pool_size = 45G

innodb_log_file_size = 500M

innodb_log_buffer_size = 64M

innodb_flush_log_at_trx_commit = 2

innodb_file_per_table = 1

innodb_file_io_threads = 4

innodb_flush_method = O_DIRECT

innodb_thread_concurrency = 0

innodb_additional_mem_pool_size = 16M

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open_files_limit = 65535

热点聚合:

©CopyRight 2010-2020 EASCK.COM Inc All Rights Reserved. 易采站长站 版权所有

微信扫一扫