Thursday, 2 January 2014

my.cnf for 64GB RAM

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-locking

interactive_timeout=180
wait_timeout=15

max_connections=9999

symbolic-links=0
skip-name-resolve

query_cache_size = 128M
query_cache_type=1
query_cache_limit=512M
key_buffer_size = 8G
max_allowed_packet = 16M

thread_cache_size = 2056
thread_concurrency = 48
myisam_sort_buffer_size = 1228M

table_cache= 8000
table_open_cache = 8000

[myisamchk]
key_buffer = 9024M

sort_buffer_size = 20M
read_buffer_size = 512M
read_rnd_buffer_size=1024M



# Try number of CPU's*2 for thread_concurrency

innodb_flush_log_at_trx_commit=0
innodb_additional_mem_pool_size = 180M
innodb_buffer_pool_size         = 32G
innodb_file_io_threads          = 4
innodb_thread_concurrency       = 33
innodb_log_buffer_size          = 20M
innodb_log_file_size            = 800M
innodb_log_files_in_group       = 3
innodb_max_dirty_pages_pct      = 90
innodb_lock_wait_timeout        = 120
innodb_file_per_table           = 1
innodb_buffer_pool_instances   = 48

slow_query_log=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet=16M

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
58 server





[mysqld]
datadir=/db/mysql
socket=/var/lib/mysql/mysql.sock
#user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-locking



log-bin
binlog-do-db=unified  # input the database which should be replicated
binlog-ignore-db=mysql            # input the database that should be ignored for replication
binlog-ignore-db=test

server-id = 5
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
master-info-file = /var/lib/mysql/mysql-master.info
relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
log-bin = /var/lib/mysql/mysql-bin






interactive_timeout=180
wait_timeout=15

max_connections=9999

symbolic-links=0
skip-name-resolve

query_cache_size = 1028M
query_cache_type=1
query_cache_limit=5012M
key_buffer_size = 8G
max_allowed_packet = 16M

thread_cache_size = 2056
thread_concurrency = 48
myisam_sort_buffer_size = 1228M

table_cache= 8000
table_open_cache = 8000

[myisamchk]
key_buffer = 9024M

sort_buffer_size = 20M
read_buffer_size = 512M
read_rnd_buffer_size=1024M



# Try number of CPU's*2 for thread_concurrency

innodb_flush_log_at_trx_commit=0
innodb_additional_mem_pool_size = 180M
innodb_buffer_pool_size         = 32G
innodb_file_io_threads          = 4
innodb_thread_concurrency       = 33
innodb_log_buffer_size          = 20M
innodb_log_file_size            = 800M
innodb_log_files_in_group       = 3
innodb_max_dirty_pages_pct      = 90
innodb_lock_wait_timeout        = 120
innodb_file_per_table           = 1
innodb_buffer_pool_instances   = 48

#slow_query_log=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet=16M


No comments:

Post a Comment