percona mysql 5.7_Percona MySQL 5.7 Linux通用二进制包安装(CentOS 6.5)

[client]

port = 3306

socket = /mysql_data_57/mysql.sock

[mysqld]

#MySQL Server layer basic setting

server-id = 1

port = 3306

socket = /mysql_data_57/mysql.sock

#MySQL Server layer directory setting

basedir = /mysql_software_57

datadir = /mysql_data_57

tmpdir = /mysql_data_57

#MySQL Server layer connection setting

max_connections = 900

#MySQL Server layer connection setting

max_connections = 900

max_connect_errors = 100000

max_allowed_packet = 16M

back_log = 50

#MySQL Server layer binlog setting

log_bin_trust_function_creators = on

expire_logs_days = 5

binlog_cache_size = 1M

log-bin = /mysql_log_57/mysql-bin

binlog_format = mixed

#MySQL Server layer memory management setting

tmp_table_size = 64M

max_heap_table_size = 64M

read_buffer_size = 2M

read_rnd_buffer_size = 16M

sort_buffer_size = 8M

join_buffer_size = 16M

query_cache_size = 0

thread_stack = 192K

query_cache_size = 0

thread_stack = 192K

#MySQL Server layer transaction management setting

transaction_isolation = READ-COMMITTED

autocommit = OFF

#MySQL Server layer log related setting

log_warnings = 2 ##this value have been the default value in MySQL 5.7

slow_query_log = ON

long_query_time = 2

slow_query_log_file = /mysql_log_57/mysql-slow.log

#log_queries_not_using_indexes = 1

#MySQL Server layer other behaviour setting

sql_mode = PIPES_AS_CONCAT,IGNORE_SPACE,STRICT_TRANS_TABLES

event_scheduler = ON

lower_case_table_names = 1

explicit_defaults_for_timestamp = ON

default-storage-engine = INNODB

explicit_defaults_for_timestamp = ON

default-storage-engine = INNODB

##ft_min_word_len = 4

# Statistic

# userstat = ON

# thread_statistics = ON

# End statistics

# MyISAM Engine related setting

key_buffer_size = 32M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 128M

myisam_max_sort_file_size = 10G

myisam_repair_threads = 1

#myisam_recover

#InnoDB Engine related setting

#InnoDB memory management related setting

innodb_buffer_pool_size = 2G

innodb_max_dirty_pages_pct = 90

innodb_sync_array_size = 16

innodb_max_dirty_pages_pct = 90

innodb_sync_array_size = 16

#table open cache related

table_open_cache = 4096

table_open_cache_instances = 16

#innodb_additional_mem_pool_size = 16M ##This variable have been removed MySQL 5.7

#innodb_numa_interleave = 1 ##Only work with Percona 5.6.27 and later

##InnoDB engine I/O related setting

innodb_write_io_threads = 8

innodb_read_io_threads = 8

innodb_flush_method = O_DIRECT

#InnoDB engine File management related setting

innodb_data_file_path = ibdata1:12M:autoextend #10M-->12M, 12M is default values, it is meaningless to set it to 10M

innodb_file_per_table = 1 #this value have been the default value in MySQL 5.7

innodb_data_file_path = ibdata1:12M:autoextend #10M-->12M, 12M is default values, it is meaningless to set it to 10M

innodb_file_per_table = 1 #this value have been the default value in MySQL 5.7

innodb_file_format = Barracuda #this value have been the default value in MySQL 5.7

#InnoDB engine undo log related setting

innodb_undo_directory = /mysql_data_57

innodb_undo_tablespaces = 4

innodb_purge_batch_size = 5000

innodb_purge_threads = 8

#InnoDB engine redo log related setting

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 8M

innodb_log_file_size = 256M

innodb_log_files_in_group = 3

innodb_log_group_home_dir = /mysql_log_57

#InnoDB engine lock and transaction management setting

innodb_lock_wait_timeout = 120

innodb_lock_wait_timeout = 120

#InnoDB engine other behaviour setting

innodb_large_prefix = ON ##this value have been the default value in MySQL 5.7

innodb_strict_mode = ON ##this value have been the default value in MySQL 5.7

innodb_checksum_algorithm = crc32 ##this value have been the default value in MySQL 5.7

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

# Only allow UPDATEs and DELETEs that use keys.

#safe-updates

[myisamchk]

key_buffer_size = 512M

sort_buffer_size = 512M

key_buffer_size = 512M

sort_buffer_size = 512M

read_buffer = 8M

write_buffer = 8M

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

# Increase the amount of open files allowed per process. Warning: Make

# sure you have set the global system limit high enough! The high value

# is required for a large number of opened tables

open-files-limit = 8192

log-error = /mysql_log_57/mysqld_error.log