[root@fxtest009 data]# 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 #sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" #.. transaction-isolation = READ-COMMITTED ## Can not Set to Slave,Otherwise Cransh MySQL! auto_increment_increment=10 # SQLNode's +1 . auto_increment_offset=4 # key_buffer = 16M # need to adjust.Only for MyISAM read_rnd_buffer_size = 2M myisam_sort_buffer_size = 2M read_buffer_size = 4M sort_buffer_size = 2M #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= 256 max_heap_table_size=128M #for "converting HEAP to MyISAM " tmp_table_size=128M #for "converting HEAP to MyISAM " query_cache_size = 64M #need to adjust. log-slow-queries = slow.log long_query_time = 1 log-queries-not-using-indexes server-id = 208 innodb_table_locks=0 innodb_buffer_pool_size = 1024M innodb_log_buffer_size = 8M innodb_log_file_size = 512M innodb_file_per_table innodb_status_file innodb_thread_concurrency= 2 #number of CPU's*2 . innodb_flush_log_at_trx_commit = 1 #innodb_force_recovery = 1 log=Cluster_master_208_log.log delayed_queue_size=500 bulk_insert_buffer_size=2M ##------------NDB Config----######## ndbcluster ndb-connectstring=10.4.6.224 ##ndb-mgmd-host=ip1,ip2 default-storage-engine=ndbcluster ndb_force_send=1 engine_condition_pushdown=1 ndb_use_exact_count=0 slave-allow-batching=0 ##1- means enable, 0 -- means disable ndb-log-update-as-write=0 ## For Slave to InnoDB . ###?Need to confirm ... ###?ndb-autoincrement-prefetch-sz 32 ###?ndb-distibution KEYHASH ###?ndb-optimized-node-selection TRUE ###?ndb-cache-check-time 0 ###?ndb-index-stat-enable TRUE ###?ndb-index-stat-cache-entries 32 ###?ndb-index-stat-update-freq 20 ###!ndb-cluster-connection-pool=4 ## Maybe have bugs at start APP. log-bin=sql-mysql-bin ## Need If .. binlog_format=ROW #ROW,MIXED,STATEMENT [mysqldump] quick max_allowed_packet = 16M