cohakim
11/22/2009 - 10:45 AM

/usr/local/etc/my.cnf

/usr/local/etc/my.cnf

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

default-storage-engine = InnoDB
explicit_defaults_for_timestamp = true
lower-case-table-names = 2

max_connections = 64
table_open_cache = 800
table_definition_cache = 400
open_files_limit = 1120

key_buffer_size = 16M
query_cache_type = 0
innodb_buffer_pool_size = 300M

read_buffer_size = 256K
read_rnd_buffer_size = 512K
join_buffer_size = 256K
sort_buffer_size = 512K

# InnoDB
innodb_file_per_table
innodb_autoextend_increment = 64
innodb_log_files_in_group = 2
innodb_log_file_size = 128M
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 0
innodb_flush_neighbors=0
innodb_thread_concurrency = 4
innodb_commit_concurrency = 4