Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "sample analysis of my.cnf configuration files in MySQL", which is easy to understand and well-organized. I hope it can help you solve your doubts. Let me lead you to study and study the "sample analysis of my.cnf configuration files in MySQL".

[client]

Default-character-set = utf8mb4

Port = PORT

Socket = / srv/myPORT/run/mysql.sock

[mysqld]

User = mysql

Port = PORT

Extra-port = 1PORT

Character_set_server = utf8mb4

Server_id = SERVER_ID

Socket = / srv/myPORT/run/mysql.sock

Basedir = / opt/percona-server

Datadir = / srv/myPORT/data

Log-error = / srv/myPORT/log/alert.log

Pid-file = / srv/myPORT/run/mysql.pid

Log_slave_updates = 1

Log-bin = / srv/myPORT/log/mysql-bin

Binlog_format = row

Binlog_cache_size = 2m

Max_binlog_cache_size = 4G

Max_binlog_size = 1G

Expire_logs_days = 7

Relay-log = / srv/myPORT/log/relay-bin

Relay-log-info-file = / srv/myPORT/log/relay-log.info

Relay-log-index = / srv/myPORT/log/relay-log.index

Master-info-file = / srv/myPORT/log/master.info

Relay-log-recovery = true

Sync-relay-log-info = 1

Explicit_defaults_for_timestamp

Key_buffer_size = 2m

Sort_buffer_size = 2m

Read_buffer_size = 2m

Read_rnd_buffer_size = 16m

Join_buffer_size = 2m

Thread_cache_size = 1024

Query_cache_size = 1m

Query_cache_limit = 1m

Query_cache_min_res_unit = 2k

Table_open_cache = 2048

Open_files_limit = 65535

Back_log = 3000

Max_connections = 4000

Max_user_connections = 2500

Max_connect_errors = 100

Max_allowed_packet = 512m

Thread_stack = 19K

Default-storage-engine = INNODB

Transaction_isolation = READ-COMMITTED

Tmp_table_size = 16m

Max_heap_table_size = 64m

Bulk_insert_buffer_size = 64m

Long_query_time = 0.5

Slow_query_log = on

Slow_query_log_file = / srv/myPORT/log/slow.log

Skip-name-resolve

Innodb_buffer_pool_size = 10G

Innodb_data_file_path = ibdata1:2G:autoextend

Innodb_file_io_threads = 24

Innodb_purge_threads = 12

Innodb_read_io_threads = 24

Innodb_write_io_threads = 24

Innodb_thread_concurrency = 24

Innodb_buffer_pool_instances = 8

Innodb_flush_log_at_trx_commit= 1

Innodb_log_buffer_size = 16m

Innodb_log_file_size = 2G

Innodb_log_files_in_group = 2

Innodb_max_dirty_pages_pct = 75

Innodb_lock_wait_timeout = 50

Innodb_file_per_table = 1

Thread_handling = pool-of-threads

Thread_pool_idle_timeout = 180

Thread_pool_max_threads = 5000

Thread_pool_size = 24

Thread_pool_oversubscribe = 10

Thread_pool_stall_limit = 500,

[mysqldump]

Quick

Max_allow_packet = 64m

[mysql]

No-auto-rehash

[mysqlhotcopy]

Interactive-timeout

The above is all the contents of the article "sample Analysis of my.cnf configuration Files in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.