欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

mysql配置文件模板

程序员文章站 2022-03-07 10:06:12
...
[client]

port            = 3306

socket          = /tmp/mysql.sock

 

# The MySQL server

[mysqld]

# Basic

#skip-grant-tables

port            = 3306

user        = mysql

basedir         = /usr/local/mysql

datadir         = /data/mysql/data

tmpdir          = /data/mysql/tmp

socket          = /tmp/mysql.sock

 

log-bin     = /data/mysql/logs/mysql-bin

log-error   = error.log

slow-query-log-file = slow.log

skip-external-locking

skip-name-resolve

log-slave-updates

explicit_defaults_for_timestamp=true

 

 

server-id       =10001

 

character-set-server = utf8

slow-query-log

binlog_format = mixed

max_binlog_size = 128M

binlog_cache_size = 1M

expire-logs-days = 5

back_log = 500

long_query_time=1

#lower_case_table_name=1

max_connections=1100

max_user_connections=1000

max_connect_errors=1000

 

wait_timeout=14400

interactive_timeout=100

 

connect_timeout = 20

slave-net-timeout=30

 

max-relay-log-size = 256M

relay-log = relay-bin

transaction_isolation = READ-COMMITTED

 

performance_schema=0

#myisam_recover

key_buffer_size = 64M

max_allowed_packet = 16M

#table_cache = 3096

table_open_cache = 6144

table_definition_cache = 4096

 

sort_buffer_size = 128K

read_buffer_size = 1M

read_rnd_buffer_size = 1M

join_buffer_size = 128K

 

myisam_sort_buffer_size = 32M

tmp_table_size = 32M

max_heap_table_size = 64M

query_cache_type=0

query_cache_size = 0

bulk_insert_buffer_size = 32M

 

thread_cache_size = 64

#thread_concurrency = 32

thread_stack = 192K

skip-slave-start

 

# InnoDB

innodb_data_home_dir = /data/mysql/data

innodb_log_group_home_dir = /data/mysql/logs

innodb_data_file_path = ibdata1:1G:autoextend

 

innodb_buffer_pool_size = 1G

 

innodb_buffer_pool_instances    = 8

#innodb_additional_mem_pool_size = 16M

innodb_log_file_size = 200M

innodb_log_buffer_size = 16M

innodb_log_files_in_group = 3

innodb_flush_log_at_trx_commit = 0

innodb_lock_wait_timeout = 10

innodb_sync_spin_loops = 40

innodb_max_dirty_pages_pct = 90

innodb_support_xa = 0

innodb_thread_concurrency = 0

innodb_thread_sleep_delay = 500

innodb_file_io_threads    = 4

innodb_concurrency_tickets = 1000

log_bin_trust_function_creators = 1

innodb_flush_method = O_DIRECT

innodb_file_per_table

innodb_read_io_threads = 16

innodb_write_io_threads = 16

innodb_io_capacity = 2000

innodb_file_format = Barracuda

innodb_purge_threads=1

innodb_purge_batch_size = 32

innodb_old_blocks_pct=75

innodb_change_buffering=all

innodb_stats_on_metadata=OFF

 

[mysqldump]

quick

max_allowed_packet = 128M

#myisam_max_sort_file_size = 10G

 

[mysql]

no-auto-rehash

max_allowed_packet = 128M

prompt                         = '(product)\u@\h [\d]> '

default_character_set          = utf8

 

 

[myisamchk]

key_buffer_size = 64M

sort_buffer_size = 512k

read_buffer = 2M

write_buffer = 2M

 

[mysqlhotcopy]

interactive-timeout

 

[mysqld_safe]

#malloc-lib= /usr/local/mysql/lib/mysql/libjemalloc.so

 

 

 

相关标签: mysql