大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说mysql-5.7.28-linux-glibc2.12-x86_64配置（参考）,希望您对编程的造诣更进一步.
[client]
socket = /data/mysql/var/mysql.sock
port = 3306
[mysqld]
#######################GENERIC##################
autocommit = OFF
connect_timeout = 10
default_authentication_plugin = mysql_native_password
default_storage_engine = InnoDB
event_scheduler = ON
interactive_timeout = 600
wait_timeout = 600
lower_case_table_names = 1
max_sort_length = 8192
max_allowed_packet = 1073741824
max_connect_errors = 100000
max_connections = 2000
max_execution_time = 0
max_user_connections = 1000
open_files_limit = 65536
net_buffer_length = 16384
port = 3306
read_only = OFF
skip_name_resolve = ON
sort_buffer_size = 2097152
read_rnd_buffer_size = 2097152
join_buffer_size = 2097152
lock_wait_timeout = 50
long_query_time = 10.000000
sync_binlog = 1
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
table_open_cache = 2000
table_open_cache_instances = 8
thread_cache_size = 9
transaction_isolation = READ-COMMIT
##########################PATH##################
basedir = /data/mysql/mysql/base
datadir = /data/mysql/data
innodb_data_home_dir = /data/mysql/data
tmpdir = /data/mysql/tmp
innodb_tmpdir = /data/mysql/tmp
pid_file = /data/mysql/var/mysql.pid
socket = /data/mysql/var/mysql.sock
log_bin = /data/mysql/log/mysql-bin
log_bin_index = /data/mysql/log/mysql-bin.index
log_error = /data/mysql/log/error.log
slow_query_log_file = /data/mysql/log/localhost-slow.log
relay_log = /data/mysql/log/relay-log
relay_log_index = /data/mysql/log/relay-log.index
relay_log_info_file = /data/mysql/log/relay-log.info
ssl-ca = /data/mysql/ssl/ca.pem
ssl-cert = /data/mysql/ssl/server-cert.pem
ssl-key = /data/mysql/ssl/server-key.pe
#########################GTID###################
gtid_mode = ON
enforce_gtid_consistency = ON
log_slave_updates = ON
#######################INNODB###################
innodb_buffer_pool_chunk_size = 134217728
innodb_buffer_pool_filename = ib_buffer_pool
innodb_buffer_pool_instances = 8
innodb_buffer_pool_size = 4294967296
innodb_change_buffer_max_size = 25
innodb_checksum_algorithm = strict_crc32
innodb_concurrency_tickets = 5000
innodb_data_file_path = ibdata1:12M;ibdata2:500M:autoextend
innodb_deadlock_detect = ON
innodb_doublewrite = ON
innodb_fast_shutdown = 1
innodb_file_per_table = ON
innodb_flush_log_at_trx_commit = 1
innodb_flush_neighbors = 1
innodb_flush_method = O_DIRECT
innodb_io_capacity = 100
innodb_io_capacity_max = 400
innodb_lock_wait_timeout = 50
innodb_log_buffer_size = 16777216
innodb_log_checksums = ON
innodb_log_compressed_pages = ON
innodb_log_file_size = 1073741824
innodb_log_files_in_group = 4
innodb_max_undo_log_size = 1073741824
innodb_online_alter_log_max_size = 134217728
innodb_open_files = 300
innodb_page_size = 16384
###########################LOG##################
binlog_cache_size = 32768
binlog_checksum = CRC32
binlog_format = ROW
binlog_rows_query_log_events = ON
expire_logs_days = 7
general_log = OFF
log_error_verbosity = 3
log_output = FILE
log_queries_not_using_indexes = ON
relay_log_info_repository = FILE
relay_log_purge = ON
slow_query_log = ON
max_binlog_size = 1073741824
max_relay_log_size = 0
#####################REPLICATION#################
server_id = 1723111203
slave_max_allowed_packet = 1073741824
slave_parallel_type = LOGICAL_CLOCK
slave_parallel_workers = 4
binlog_transaction_dependency_tracking = WRITESET
binlog_transaction_dependency_history_size = 25000
transaction_write_set_extraction = XXHASH64
sync_master_info = 10000
sync_relay_log = 10000
sync_relay_log_info = 10000 代码100分
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/10452.html
