[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
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