[client]
port = 3636
socket = /tmp/mysql.sock
[mysqld]
#event_scheduler = ON
port = 3636
socket = /tmp/mysql.sock
bind-address = 10.10.114.2
# * Fine Tuning
key_buffer = 4G
key_buffer_size = 4096M
max_heap_table_size = 512M
max_allowed_packet = 16M
thread_stack = 512k
thread_cache_size = 100
table_open_cache = 524288
table_cache = 55296
tmp_table_size = 1024M
max_connections = 1500
net_buffer_length = 8K
thread_concurrency = 64
myisam_sort_buffer_size = 32M
sort_buffer_size = 2M
read_buffer_size = 2M
join_buffer_size = 2M
read_rnd_buffer_size = 2M
query_cache_size = 256M
query_cache_limit = 4M
query_cache_type = 1
connect_timeout = 30
#general_log_file = /var/log/mysql/mysql.log
general_log = 1
innodb_buffer_pool_size = 4G
innodb_additional_mem_pool_size = 1024M
innodb_log_buffer_size = 128M
innodb_thread_concurrency = 32
innodb_commit_concurrency = 32
innodb_flush_method = O_DIRECT
myisam_use_mmap = 0
# * Replication
server-id = 1
log-bin = mysql-bin
binlog_format = mixed
expire_logs_days= 10
max_binlog_size = 100M
sync_binlog = 1
binlog_format = row
slow_query_log_file = mysql-slow.log
log_bin_trust_function_creators = 1
innodb_flush_log_at_trx_commit = 1
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size= 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
#socket= /tmp/mysqld.sock
default_time_zone=Asia/Jakarta
0 comments:
Posting Komentar