# Disable tcp socket connections. only unix/linux socket connections are allowed.
Skip_networking
# Disable DNS resolution to speed up connection
Skip_name_resolve
# Skip the authorization table and use it when you forget the root password
# Skip-grant-tables
# Default storage engine
# Default-storage-engine = MyISAM/INNODB
# Default Character set
Character_set_server = utf8
# Maximum number of connections
Max_connections = 20480
# Maximum number of connections per user
Max_user_connection= 1024
# Number of seconds before the server closes an interactive connection. the default value is 28800.
Interactive_timeout = 7200
# Number of thread caches. use idle connections to create a new connection. 1G> 8 2G> 16 3G> 32> 3G> 64
# You can add this value when many short connections exist.
Thread_cache_size = 64
# Buffer for data sorting (eg: order/group by) in a single thread (connection). one-time allocation during connection creation. the default value is 2 MB. this value can be increased when Sort_merge_passes is large.
Sort_buffer_size = 2 M
# Buffer for join operations on tables without indexes. the default value is 256 kB. one-time allocation during connection creation
Join_buffer_size = 262144
# Specify the size of the connection listening queue. this parameter is invalid when the value exceeds OS tcp_max_syn_backlog/somaxconn. we recommend that you set this parameter to an integer smaller than 512.
Back_log = 512
# Table_open_cache number of tables that can be opened at the age
Table_open_cache = 256
# The maximum number of messages transmitted at a time, which is the maximum value of net_buffer_length
Max_allowed_packet = 8 M
# Bin-log
# Enable binary log
Log-bin = mysql-bin
Log-bin-index = mysql-bin.index
# Log Format. optional values: row, statement, and mixed. the default value is statement. mixed is recommended.
Binlog_format = mixed
# Maximum value of a binlog
Max_binlog_size = 1G
# Binlog cache size for a single connection. the default value is 1 MB.
Binlog_cache_size = 2 M
# Total binlog cache size
Max_binlog_cache_size = 2G
# Sync_binlog may be 0 or 1
# Whether the binlog is synchronized to the disk. if it is 0, it is handed over to the OS. if it is 1, it is synchronized immediately after the transaction ends, causing high IO consumption.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.