Created
May 31, 2012 12:52
-
-
Save yamingd/2843213 to your computer and use it in GitHub Desktop.
mysql config collection from internet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
################################################################################ | |
## 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