32 GB server memory configuration, my. the cnf parameter is estimated to be 32 GB memory, for mysql server configuration parameter changes, it is recommended that innodb_file_per_table = 1 open the independent tablespace back_log = 300 # back_log is the number of connections that the operating system can maintain in the listening queue max_connections = 8000 # number of simultaneous sessions allowed by the MySQL Service max_connect_errors = 30 # maximum number of errors allowed for each client connection table_cache = 4096 # number of tables opened by all threads open_files_limit = 10240max_allowed_packet = 32 M # size of each connection. dynamically increase the size of wait_timeout = 10 # specify the maximum connection time of a request sort_buffer_size = 16 M # The sort buffer is used to process the sort join_buffer_size = 16 M caused by order by and group by queues # this buffer is used to optimize full Union (full JOINs union without indexes ). query_cache_size = 128 M # The Query Buffer is often used to buffer SELECT results and will not be executed directly return results next time the same query transaction_isolation = REPEATABLE-READ # Set the default transaction isolation level thread_stack = 512 K # The heap size used by the thread. this capacity is reserved for each connection. log-bin = mysql-bin # enable the binary log function innodb_buffer_pool_size = 6G # InnoDB uses a buffer pool to store indexes and raw data on an independent database server, you can set this variable to 80% innodb_file_io_threads = 4 # Number of I/o threads used to synchronize IO operations innodb_thread_concurrency = 16 # Number of threads allowed in the InnoDb core innodb_log_buffer_size = 16 M # the buffer size used to buffer log data. innodb_log_file_size = 512 M size of each log file in the log group. innodb_log_files_in_group = 3 # Total number of files in the log group innodb_lock_wait_timeout = 120 # How long should an InnoDB Transaction wait for a lock to be approved before being rolled back;