mysql5.6 配置文件在哪里,mysql5.6 配置 文件

mysql 3306 主库配置文件

[client]

port = 3306

default-character-set=utf8mb4

socket = /ssd/mysql/3306/tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

secure_file_priv="/"

#!include /ssd/mysql/3306/etc/mysqld.cnf

skip-slave-start

character-set-server=utf8mb4

slave-skip-errors = 1062

log-slave-updates

server-id=146

performance_schema = on

port = 3306

basedir = /usr/local/mysql

socket = /ssd/mysql/3306/tmp/mysql.sock

pid-file = /ssd/mysql/3306/data/mysql.pid

datadir = /ssd/mysql/3306/data

tmpdir = /ssd/mysql/3306/tmp

slave-load-tmpdir = /ssd/mysql/3306/tmp

skip-external-locking

skip-name-resolve

max_connections = 4000

max_connect_errors = 4000

back_log=600

wait_timeout=150

interactive_timeout=150

default_storage_engine=innodb

character_set_server=utf8mb4

key_buffer_size = 128M

max_allowed_packet = 128M

table_open_cache = 2048

thread_cache_size = 1000

query_cache_size = 256M

thread_concurrency = 48

log-bin = mysql-bin

#log-bin = 0

relay-log = relay-log

relay_log_index = relay-log.index

log-warnings = 1

log-error = /ssd/mysql/3306/log/mysql.err

slow_query_log = 1

long-query-time = 2

slow_query_log_file = /ssd/mysql/3306/log/slow.log

#general_log = 1

#general_log_file = /ssd/mysql/3306/log/mysql.log

max_binlog_size = 1G

max_relay_log_size = 1G

expire_logs_days = 7

binlog_cache_size = 64M

replicate-wild-ignore-table = mysql.%

replicate-wild-ignore-table = test.%

relay-log-purge = 1

key_buffer_size = 64M

sort_buffer_size = 16M

read_buffer_size = 16M

join_buffer_size = 16M

read_rnd_buffer_size = 64M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 64M

myisam_max_sort_file_size = 256M

myisam_repair_threads = 1

myisam_recover_options

group_concat_max_len = 64K

transaction_isolation = REPEATABLE-READ

innodb_file_per_table

innodb_file_format = Barracuda

innodb_additional_mem_pool_size = 100M

innodb_buffer_pool_size = 25G

innodb_data_home_dir = /ssd/mysql/3306/data

innodb_data_file_path = ibdata1:1G:autoextend

innodb_file_io_threads = 4

innodb_read_io_threads =48

innodb_write_io_threads =48

innodb_io_capacity =600

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 2

tmp_table_size = 128M

innodb_log_buffer_size = 16M

innodb_log_file_size = 512M

innodb_log_files_in_group = 2

innodb_log_group_home_dir = /ssd/mysql/3306/data

innodb_max_dirty_pages_pct = 90

innodb_lock_wait_timeout = 120

log-bin=mysql-bin

binlog_format=mixed

innodb_flush_method=O_DIRECT

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 64M

sort_buffer_size = 64M

read_buffer = 2M

write_buffer = 2M

[xtrabackup]

default-character-set = utf8

mysql 3336 从库配置文件

[client]

port = 3336

default-character-set=utf8mb4

socket = /ssd/mysql/3336/tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

secure_file_priv="/"

#!include /ssd/mysql/3336/etc/mysqld.cnf

skip-slave-start

character-set-server=utf8mb4

slave-skip-errors = 1062

log-slave-updates

server-id=147

performance_schema = on

port = 3336

basedir = /usr/local/mysql

socket = /ssd/mysql/3336/tmp/mysql.sock

pid-file = /ssd/mysql/3336/data/mysql.pid

datadir = /ssd/mysql/3336/data

tmpdir = /ssd/mysql/3336/tmp

slave-load-tmpdir = /ssd/mysql/3336/tmp

skip-external-locking

skip-name-resolve

max_connections = 4000

max_connect_errors = 4000

back_log=600

wait_timeout=150

interactive_timeout=150

default_storage_engine=innodb

character_set_server=utf8mb4

key_buffer_size = 128M

max_allowed_packet = 128M

table_open_cache = 2048

thread_cache_size = 1000

query_cache_size = 256M

thread_concurrency = 48

log-bin = mysql-bin

#log-bin = 0

relay-log = relay-log

relay_log_index = relay-log.index

log-warnings = 1

log-error = /ssd/mysql/3336/log/mysql.err

slow_query_log = 1

long-query-time = 2

slow_query_log_file = /ssd/mysql/3336/log/slow.log

#general_log = 1

#general_log_file = /ssd/mysql/3336/log/mysql.log

max_binlog_size = 1G

max_relay_log_size = 1G

expire_logs_days = 7

binlog_cache_size = 64M

replicate-wild-ignore-table = mysql.%

replicate-wild-ignore-table = test.%

relay-log-purge = 1

key_buffer_size = 64M

sort_buffer_size = 16M

read_buffer_size = 16M

join_buffer_size = 16M

read_rnd_buffer_size = 64M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 64M

myisam_max_sort_file_size = 256M

myisam_repair_threads = 1

myisam_recover_options

group_concat_max_len = 64K

transaction_isolation = REPEATABLE-READ

innodb_file_per_table

innodb_file_format = Barracuda

innodb_additional_mem_pool_size = 100M

innodb_buffer_pool_size = 25G

innodb_data_home_dir = /ssd/mysql/3336/data

innodb_data_file_path = ibdata1:1G:autoextend

innodb_file_io_threads = 4

innodb_read_io_threads =48

innodb_write_io_threads =48

innodb_io_capacity =600

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 2

tmp_table_size = 128M

innodb_log_buffer_size = 16M

innodb_log_file_size = 512M

innodb_log_files_in_group = 2

innodb_log_group_home_dir = /ssd/mysql/3336/data

innodb_max_dirty_pages_pct = 90

innodb_lock_wait_timeout = 120

log-bin=mysql-bin

binlog_format=mixed

innodb_flush_method=O_DIRECT

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 64M

sort_buffer_size = 64M

read_buffer = 2M

write_buffer = 2M

[xtrabackup]

default-character-set = utf8