MySQL Configuration

0.readme

http://alinux.web.id/tags/MySQL.html

mm-1.my.cnf

##[root@srv14 ~]# cat /etc/my.cnf
[mysqld]
port=3306
datadir=/home/mysql/
socket=/usr/local/mysql/tmp/mysql.sock
user=mysql
old_passwords=0
#symbolic-links=0
#query_cache_size = 268435456
query_cache_size = 256M
query_cache_type=1
query_cache_limit = 1048576

log = 1
long_query_time = 1
slow_query_log	= 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
general_log	= 1
general_log_file =	/var/log/mysqld.log

server_id           = 1
log_bin             = /var/log/mysql/mysql-bin.log 
log_bin_index       = /var/log/mysql/mysql-bin.log.index 
relay_log           = /var/log/mysql/mysql-relay-bin 
relay_log_index     = /var/log/mysql/mysql-relay-bin.index 
expire_logs_days    = 10 
max_binlog_size     = 100M 
log_slave_updates   = 1

bind-address = 0.0.0.0
local-infile = 0

mm-2.my.cnf

##[root@srv15 ~]# cat /etc/my.cnf
[mysqld]
port=3306
datadir=/home/mysql
socket=/usr/local/mysql/tmp/mysql.sock
user=mysql
old_passwords=0
#symbolic-links=0
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

log = 1
long_query_time = 1
slow_query_log	= 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
general_log	= 1
general_log_file =	/var/log/mysqld.log

server_id           = 2
log_bin             = /var/log/mysql/mysql-bin.log
log_bin_index       = /var/log/mysql/mysql-bin.log.index
relay_log           = /var/log/mysql/mysql-relay-bin
relay_log_index     = /var/log/mysql/mysql-relay-bin.index
expire_logs_days    = 10
max_binlog_size     = 100M
log_slave_updates   = 1

bind-address = 0.0.0.0
local-infile = 0
[root@srv15 ~]# 

my.cnf

#http://alinux.web.id/2011/08/14/compiling-mysql-5.5.12-with-cmake-on-centos.html
[mysqld]
port=3306
datadir=/home/mysql/
socket=/usr/local/mysql/tmp/mysql.sock
user=mysql
old_passwords=0
#symbolic-links=0
#query_cache_size = 268435456
query_cache_size = 256M
query_cache_type=1
query_cache_limit = 1048576

long_query_time = 1
slow_query_log	= 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
general_log	= 1
general_log_file =	/var/log/mysqld.log

#server_id           = 1
#log_bin             = /var/log/mysql/mysql-bin.log 
#log_bin_index       = /var/log/mysql/mysql-bin.log.index 
#relay_log           = /var/log/mysql/mysql-relay-bin 
#relay_log_index     = /var/log/mysql/mysql-relay-bin.index 
#expire_logs_days    = 10 
#max_binlog_size     = 100M 
#log_slave_updates   = 1

bind-address = 0.0.0.0
local-infile = 0