[mysqld] pid_file=/var/run/mysqld.pid socket=/var/mysql/mysql.sock server-id = 12 lower_case_table_names=0 # replication (slave) master-host = pe1 master-user = repl master-password = XXXXXX replicate-ignore-db = test replicate-ignore-db = ccnbench replicate-ignore-table = ccn.SITE_INDEX_WORD_POSITION replicate-ignore-table = ccn.SITE_INDEX_ENTRY relay-log=xs2-relay-bin # binary logs for replication (master) #max_binlog_size=500M #log-bin=/var/db/mysql/xs2-binlog #log-slave-updates datadir=/var/db/mysql skip-locking #delay-key-write=ALL myisam-recover=BACKUP,FORCE max_connections=50 max_allowed_packet=4M table_cache=1024 thread_cache_size=4 tmp_table_size=100M # global key_buffer_size=200M query_cache_size=200M query_cache_limit=2M query_cache_type=1 # per thread sort_buffer_size=2M myisam_sort_buffer_size=2M read_buffer_size=2M read_rnd_buffer_size=2M log-slow-queries=/var/db/mysql/slow_queries.log #long_query_time=3 #log-long-format skip-innodb #innodb_file_per_tablespace #innodb_buffer_pool_size=800M #innodb_additional_mem_pool_size=200M #innodb_flush_log_at_trx_commit=2 #log-warnings [mysql.server] basedir=/usr/local/mysql datadir=/var/db/mysql pid-file=/var/db/mysql/mysqld.pid user=mysql [mysqld_safe] log-error=/var/log/mysqld.log [mysqldump] quick max_allowed_packet=16M user=repmgr password=r3pl!c@t3 socket=/var/mysql/mysql.sock [mysql] no-auto-rehash socket=/var/mysql/mysql.sock [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout user=repmgr password=XXXXXX