Skip to content

Instantly share code, notes, and snippets.

@yamingd
Created May 31, 2012 12:52
Show Gist options
  • Save yamingd/2843213 to your computer and use it in GitHub Desktop.
Save yamingd/2843213 to your computer and use it in GitHub Desktop.
mysql config collection from internet
################################################################################
## Kontrollkit
## NAME: mt-my.cnf_2GB
## DATE: 2008-10-01
## AUTHOR: Matt Reid
## WEBSITE: http://kontrollsoft.com
## EMAIL: themattreid@gmail.com
## LICENSE: BSD http://www.opensource.org/licenses/bsd-license.php
################################################################################
# WHAT THIS IS
#MySQL 5.0.x settings for 2GB RAM dedicated server
################################################################################
[mysqld_safe]
nice = -15
[client]
socket = /var/lib/mysql/mysql.sock
[mysqld]
## Files
back_log = 300
open-files-limit = 8192
open-files = 1024
port = 3306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysql.pid
skip-external-locking
skip-name-resolve
## Logging
relay_log=/var/lib/mysql/mysql-relay-bin
relay_log_index=/var/lib/mysql/mysql-relay-index
#log=/var/lib/mysql/mysql-gen.log
log_error=/var/lib/mysql/mysql-error
log_warnings
log_bin=/var/lib/mysql/mysql-bin
log_slow_queries=/var/lib/mysql/mysql-slow.log
#log_queries_not_using_indexes
long_query_time = 10
max_binlog_size = 1024M
expire_logs_days = 10
log-slave-updates = 1
## Buffers and Connections
key_buffer = 2M
max_allowed_packet = 32M
thread_stack = 32K
thread_cache_size = 150
table_cache = 128
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
join_buffer_size = 1M
query_cache_size = 4M
query_cache_limit = 512K
max_connections = 100
max_connect_errors = 100
concurrent_insert=2
connect_timeout=30
## Default Table Settings
default_table_type = INNODB
sql_mode = NO_AUTO_CREATE_USER
## Alt settings
max_heap_table_size = 64M
bulk_insert_buffer_size = 16M
tmp_table_size = 32M
## Number of CPU's*2 for thread_concurrency
thread_concurrency = 4
## Replication
#server_id =
#read_only
#skip-slave-error=
## MyISAM Engine
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 2M
myisam_max_extra_sort_file_size = 2M
myisam_repair_threads = 4
myisam_recover=BACKUP
## InnoDB Engine
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:64M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_file_size=32M
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 16M
innodb_file_io_threads = 4
innodb_status_file
innodb_file_per_table
innodb_flush_log_at_trx_commit = 1
innodb_table_locks=0
innodb_log_buffer_size = 32M
innodb_lock_wait_timeout = 60
innodb_thread_concurrency=16
innodb_commit_concurrency=8
innodb_flush_method=O_DIRECT
innodb_support_xa=0
sync_binlog=1
## TX Isolation
transaction-isolation=REPEATABLE-READ
[mysqldump]
quick
quote-names
max_allowed_packet = 128M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment