I have 2 servers, both are slaves in db replication. both are dual xeons. 1 has 2 gigs of ram, and the other has 1 gig of ram. How can i optimize the cnf file to reflect that the only thing these 2 servers do are mysql (in slave mode)
here is my cnf file, both are the same btw:
[mysqld]
log-bin
server-id = 2
log-slave-updates
log-warnings
replicate-ignore-db=mysql
replicate-ignore-db=eximstats
replicate-ignore-db=horde
replicate-ignore-db=mail
master-host=HOST
master-user=USER
master-password=PASS
master-port=3306
set-variable = max_connections=800
safe-show-database
max_allowed_packet = 16777216
max_heap_table_size = 1073741824
#added these
max_connect_errors = 10000
key_buffer = 16M
table_cache = 1500
sort_buffer_size = 3M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 1500
query_cache_size = 32M
thread_concurrency = 4
# Set buffer pool size to 50-80% of your computer's memory
set-variable = innodb_buffer_pool_size=512M
set-variable = innodb_additional_mem_pool_size=70M
#
# Set the log file size to about 25% of the buffer pool size
set-variable = innodb_log_file_size=128M
set-variable = innodb_log_buffer_size=68M
#
innodb_flush_log_at_trx_commit=1
#added this one to point mysql databases to the other drive
datadir=/backup/dbs
#socket=/var/lib/mysql/mysql.sock
#[mysql.server]
#user=mysql
#basedir=/backup/dbs
#[safe_mysqld]
#err-log=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
