You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
38 lines
823 B
38 lines
823 B
[client]
|
|
|
|
# The MySQL server
|
|
[mysqld]
|
|
skip-external-locking
|
|
skip-name-resolve
|
|
back_log = 50
|
|
max_connections = 2048
|
|
max_connect_errors = 1000
|
|
table_open_cache = 1024
|
|
open_files_limit = 16384
|
|
max_allowed_packet = 16M
|
|
read_buffer_size = 8M
|
|
read_rnd_buffer_size = 32M
|
|
sort_buffer_size = 2M
|
|
join_buffer_size = 2M
|
|
thread_cache_size = 64
|
|
query_cache_size = 64M
|
|
query_cache_limit = 4M
|
|
slow_query_log = 1
|
|
long_query_time = 2
|
|
lower_case_table_names = 1
|
|
innodb_file_per_table = 1
|
|
max_allowed_packet = 1G
|
|
server-id = 1
|
|
log-bin = mysql-bin
|
|
expire_logs_days = 7
|
|
binlog_format = ROW
|
|
|
|
innodb_data_file_path = ibdata1:12M:autoextend
|
|
innodb_buffer_pool_size = 2G
|
|
innodb_write_io_threads = 12
|
|
innodb_read_io_threads = 8
|
|
innodb_flush_log_at_trx_commit = 2
|
|
innodb_log_buffer_size = 16M
|
|
innodb_log_file_size = 170M
|
|
innodb_lock_wait_timeout = 60
|