32 GB server memory configuration, bitsCN.com estimated by the my. cnf parameter
32 GB server memory configuration, my. cnf Parameter estimation
32 GB memory, mysql server configuration parameter change suggestions
Bytes ----------------------------------------------------------------------------------------------------------------
Innodb_file_per_table = 1
Open independent tablespace
Back_log = 300
# Back_log indicates the number of connections that the operating system can maintain in the listening queue.
Max_connections = 8000
# Maximum number of concurrent 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 = 10240
Max_allowed_packet = 32 M
# Independent size of each connection. The size increases dynamically
Wait_timeout = 10
# Specify the maximum connection time of a request
Sort_buffer_size = 16 M
# Sort buffering is used to process sorting caused by order by and group by queues.
Join_buffer_size = 16 M
# This buffer is used to optimize full union (full JOINs without indexes ).
Query_cache_size = 128 M
# Query buffering is often used to buffer SELECT results and no direct return results will be executed in the next 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 independently used database server, you can set this variable to 80% of the server's physical memory size.
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
The 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;
BitsCN.com