[root@mfx226 ~]# cat /etc/my.cnf [CLIENT] port = 3306 socket = /tmp/mysql.sock [MYSQLD] port = 3306 socket = /tmp/mysql.sock #------------------Global------------------------- skip-locking skip-name-resolve default-character-set=cp932 key_buffer = 128M # need to adjust.Only for MyISAM read_rnd_buffer_size = 32M myisam_sort_buffer_size = 64M read_buffer_size = 16M sort_buffer_size = 16M #Only For Full Table Join buffer . table_cache = 512 #Need to adjust. back_log = 500 thread_concurrency = 2 #Number of CPU's*2 . thread_cache_size = 32 max_allowed_packet = 16M max_connect_errors=100 max_connections = 1024 max_tmp_tables= 128 max_heap_table_size=64M #for "converting HEAP to MyISAM " tmp_table_size=64M #for "converting HEAP to MyISAM " query_cache_size = 32M #need to adjust. log-slow-queries = slow.log long_query_time = 1 log-queries-not-using-indexes server-id = 226 innodb_table_locks=0 innodb_buffer_pool_size = 350M innodb_log_buffer_size = 16M innodb_log_file_size = 512M innodb_file_per_table innodb_status_file innodb_thread_concurrency= 2 #number of CPU's*2 . master-host = 10.4.6.208 master-user = root master-password = 123456 master-port = 3306 replicate-do-db = MAINX replicate-do-db = mysql replicate-ignore-table=mysql.ndb_apply_status skip-slave-start relay-log=mfx226-relay-bin log=SlaveDB_log.log [mysqldump] quick max_allowed_packet = 16M